Regarding access to a user

From: Shashwat_Nigam <Shashwat_Nigam(at)satyam(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Regarding access to a user
Date: 2008-08-20 06:41:44
Message-ID: B3F7216EEA3D5D49A0841DFC6843C33AB9BC9B@HSTMBX004.corp.satyam.ad
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-sql

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<mailto:shashwat_nigam(at)satyam(dot)com>
| Software Engineer | Geographical Information System
Satyam Computer Services Limited<http://www.satyam.com/>, 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2008-08-20 07:12:58 Re: [GENERAL] cache lookup failed
Previous Message c k 2008-08-19 18:01:12 cache lookup failed

Browse pgsql-general by date

  From Date Subject
Next Message johnf 2008-08-20 06:45:21 Re: Restarting with pg_ctl, users, and passwords.
Previous Message Tovo Rabemanantsoa 2008-08-20 06:33:35 Re: How do I determine my data dir for a created database for pg_ctl?

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Grittner 2008-08-20 13:10:59 Re: Regarding access to a user
Previous Message Tom Lane 2008-08-19 21:21:56 Re: LIMIT question