Skip site navigation (1) Skip section navigation (2)

Re: question about phppgadmin

From: osman mohamad <osman_m(at)ieee(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: question about phppgadmin
Date: 2010-10-18 07:08:18
Message-ID: AANLkTikkjxU+t8AxcXQ9QQGoh6bPPox_EV2zU3mET=_w@mail.gmail.com (view raw or flat)
Thread:
Lists: 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.
>

In response to

pgsql-admin by date

Next:From: Robert GravsjöDate: 2010-10-18 09:22:23
Subject: Re: pg_ident.conf not working?
Previous:From: Greg SmithDate: 2010-10-17 19:45:16
Subject: Re: Restricting schema sizes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group