Regarding access to a user - Mailing list pgsql-general

From Shashwat_Nigam
Subject Regarding access to a user
Date
Msg-id B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad
Whole thread Raw
Responses Re: [ADMIN] Regarding access to a user
List pgsql-general

Dear Team

 

First of all I would like to thank you to provide a spatial database fro GIS developers and user. But I have doubt in the usage. I have created a few databases (i.e. X, Y, Z)  in a default Server and I also created a user (i.e. Us). Now what I want is to set privilege that whenever the user log in as Us he can only see database Y, none other than that. The user Us could have all rights for database Y but can’t  go for any other database (X or Z). I already tried for GRANT command but it doesn’t seems to be fruitful as such.

Please provide some assistance regarding the same as it is very required for the further proceeding of my work.

Thanks & Regards,

Shashwat Nigam

| Software Engineer | Geographical Information System

Satyam Computer Services Limited, Hyderabad | MOBILE: +919951467324 | 

 



DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: cache lookup failed
Next
From: Tom Tom
Date:
Subject: Re: Re: pg_restore fails on Windows