Re: question about phppgadmin - Mailing list pgsql-admin

From osman mohamad
Subject Re: question about phppgadmin
Date
Msg-id AANLkTikkjxU+t8AxcXQ9QQGoh6bPPox_EV2zU3mET=_w@mail.gmail.com
Whole thread Raw
In response to question about phppgadmin  (osman mohamad <osman_m@ieee.org>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Greg Smith
Date:
Subject: Re: Restricting schema sizes
Next
From: Robert Gravsjö
Date:
Subject: Re: pg_ident.conf not working?