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 tables ?
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 | superuser, create database > > > And as postgres I ran: > REVOKE ALL ON SCHEMA public FROM testuser; I forgot to mention something which led to the confusion. testuser doesn't probably have permissions on the public schema, but public (all users) does. You probably need to revoke it from PUBLIC and grant it to the users who should have creation rights to public. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
