Stijn Hoop <stijn@xxxxxxxxxx> 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
