Re: Keep a user from creating tables ? - Mailing list pgsql-admin

From Stephan Szabo
Subject Re: Keep a user from creating tables ?
Date
Msg-id 20040517080153.P21709@megazone.bigpanda.com
Whole thread Raw
In response to Keep a user from creating tables ?  ("Gregory S. Williamson" <gsw@globexplorer.com>)
List pgsql-admin
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 the user not have rights to create objects in any schemas. Most
likely you'd only need to change the public schema, but if you've granted
create rights for other schemas you'll need to revoke those as well.

pgsql-admin by date:

Previous
From: "Gregory S. Williamson"
Date:
Subject: Keep a user from creating tables ?
Next
From: Lamar Owen
Date:
Subject: Re: Installing PostgreSQL on Fedora from RPM