Skip site navigation (1) Skip section navigation (2)

Keep a user from creating tables ?

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Keep a user from creating tables ?
Date: 2004-05-17 04:02:13
Message-ID: 71E37EF6B7DCC1499CEA0316A2568328010579A6@loki.wc.globexplorer.net (view raw or flat)
Thread:
Lists: pgsql-admin
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));
CREATE TABLE
test=> drop table foo;
DROP TABLE
test=> create temporary table foo (man INT,choo VARCHAR(2));
ERROR:  permission denied to create temporary tables in database "test"
test=>

============

I'm sure this is obvious but I'm not seeing it ... not just temporary, but all tables should be disallowed.

TIA,

Greg Williamson
DBA
GlobeXplorer LLC


Responses

pgsql-admin by date

Next:From: Saket BagadeDate: 2004-05-17 10:42:12
Subject: Data/Index consistency checking in PostgreSQL
Previous:From: Jared EvansDate: 2004-05-17 01:54:55
Subject: Re: How to determine if ODBC was compiled in?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group