Re: revoke on database not working as expected - Mailing list pgsql-general

Stijn Hoop <stijn@win.tue.nl> writes:
> template1=# revoke all on database privtest from testpriv;

That doesn't do what you evidently think it does --- it revokes the
right to create temp tables, and the right to create new schemas, but
not every right in existence.  Please read the GRANT/REVOKE manual
pages.  (Hint: revoking CREATE on the public schema would get you closer
to what you want.)

            regards, tom lane