Re: Keep a user from creating tables ?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Keep a user from creating tables ?
Date: 2004-05-17 15:03:41
Message-ID: 20040517080153.P21709@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ulrich Meis 2004-05-17 15:08:10 How do I grant access to entire database at once(schemas,tables,sequences,...)?
Previous Message Saket Bagade 2004-05-17 10:42:12 Data/Index consistency checking in PostgreSQL