Hi all,



Sorry if this is an already answered question. I'm having some troubles to
set privileges to a user (role). I have to roles, postgres (the superuser)
and roger, I created a database 'test' with postgres role and I want that
roger have only SELECT, INSERT, UPDATE and DELETE on that database, so I
tried:



REVOKE ALL ON DATABASE test FROM roger;



GRANT SELECT, UPDATE, INSERT, DELETE ON <table_name> TO roger;



But the role roger can still create objects in this database and I don't
want it!



Any HELP???



Thanks!!!











Rodrigo Sakai

Administrador de Banco de Dados

*(11) 3750-7075

* rodrigo.sakai@zanthus.com.br

"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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings