From: | Vladimir Rusinov <vladimir(at)greenmice(dot)info> |
---|---|
To: | osman mohamad <osman_m(at)ieee(dot)org> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: question about phppgadmin |
Date: | 2010-09-29 07:34:40 |
Message-ID: | AANLkTikj5pDdgHic16M8_OiVN9WbkS9HqRJ_w7su8kZ+@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Tue, Sep 28, 2010 at 5:31 PM, osman mohamad <osman_m(at)ieee(dot)org> 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Michal Glowacki | 2010-09-29 07:52:05 | Hot standby server does not start |
Previous Message | Vishnu S. | 2010-09-29 05:03:58 | Re: Slony-I installation Package compatible with PostgreSQL 8.4 |