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

[GENERAL] revoke on database not working as expected

2005-08-29 Thread Stijn Hoop
Hi, I'm running into a setup problem (I guess) while trying to prevent a user from creating tables in a database. The setup is a FreeBSD 5.4 database server accessed from a FreeBSD 6.0 development box, both running PostgreSQL 8.0.3. This is what I have configured on the database server (firsa):