Postgres Pro
Downloads
Home   >   mailing lists

Re: ROLES and PRIVILEGES - Mailing list pgsql-admin

From Tom Lane
Subject Re: ROLES and PRIVILEGES
Date
Msg-id 1982.1153926313@sss.pgh.pa.us
Whole thread Raw
In response to ROLES and PRIVILEGES  ("Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br>)
List pgsql-admin
Tree view 
"Rodrigo Sakai" <rodrigo.sakai@zanthus.com.br> writes:
>   But the role roger can still create objects in this database and I don't
> want it!

revoke create on the public schema ... database-level privileges are not
the issue here.  See the GRANT manual page.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Rodrigo Sakai"
Date:
Subject: ROLES and PRIVILEGES
Next
From: Hovik Avedian
Date:
Subject: Starting PostgreSQL from a windows application