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