Stijn Hoop <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings