On Tue, Sep 28, 2010 at 5:31 PM, osman mohamad <osman_m@xxxxxxxx> wrote:
when I create a user "user1" and give this user theÂpermissions on aÂdatabase "db1"Â(including login privilage),
this user can accessÂall databases although it doesn't have the privilges (even after implmenting theÂrevoke command)
on the other hand, any user can accessÂthe database "db1"
after login, although I make (revokeÂallÂonÂdatabaseÂdb1ÂfromÂpublic ).ÂI need to restrict role "user1" to access only db1 and db2's sch_a and shc_f, and also don't show the other schemas in the same database. When listing databases, just two schemas should be shown (sch_a , sch_f).
Did user1 have CREATEROLE and CREATEDBÂprivileges? If so, it is a superuser and can access any database. Revoke this privs from user and all restrictions would work.
--
Vladimir Rusinov
http://greenmice.info/
