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 schemas, but
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):
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