]
Sent: Mon 5/17/2004 8:03 AM
To: Gregory S. Williamson
Cc: [EMAIL PROTECTED]
Subject:Re: [ADMIN] Keep a user from creating tables ?
On Sun, 16 May 2004, Gregory S. Williamson wrote:
In postgres 7.4, is there any way to stop a user from creating tables in a given
database ?
Make
On Mon, 17 May 2004, Gregory S. Williamson wrote:
Stephan,
Thanks for the info, but alas, no success.
I have:
List of database users
User name | User ID | Attributes
---+-+
testuser | 100 |
postgres | 1 |
Of course ... implicit in the docs if I reread them.
Thanks very much for the tip ...
G
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Monday, May 17, 2004 1:45 PM
To: Gregory S. Williamson
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Keep a user from creating
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