Re: [GENERAL] revoke on database not working as expected

2005-08-30 Thread Stijn Hoop
On Mon, Aug 29, 2005 at 03:07:59PM -0400, Tom Lane wrote: > 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 schem

Re: [GENERAL] revoke on database not working as expected

2005-08-29 Thread Tom Lane
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