Re: [ADMIN] Regarding access to a user

>>> Shashwat_Nigam <Shashwat_Nigam@satyam.com> wrote:

> 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).

The first thing you need to do is configure "host based
authentication":

http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html

Among other things, this allows you to restrict which users can
connect to which databases.

-Kevin

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin