>>> Shashwat_Nigam <Shashwat_Nigam@xxxxxxxxxx> 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
