In postgres 7.4, is there any way to stop a user from creating tables in a given database ?
I tried (as postgres user):
REVOKE ALL ON DATABASE test FROM testuser;
testuser can still connect and can still select from the tables I want them to see, but as user "testuser":
test=> CREATE TABLE foo(man INT,choo VARCHAR(2));
test=> drop table foo;
test=> create temporary table foo (man INT,choo VARCHAR(2));
ERROR: permission denied to create temporary tables in database "test"
I'm sure this is obvious but I'm not seeing it ... not just temporary, but all tables should be disallowed.
pgsql-admin by date
|Next:||From: Saket Bagade||Date: 2004-05-17 10:42:12|
|Subject: Data/Index consistency checking in PostgreSQL|
|Previous:||From: Jared Evans||Date: 2004-05-17 01:54:55|
|Subject: Re: How to determine if ODBC was compiled in?|