>>> Shashwat_Nigam <[EMAIL PROTECTED]> 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-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
