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