"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