> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of webmaster
> Sent: Tuesday, May 28, 2002 9:03 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Database Rights
>
> I noticed that as I create Databases and add users in psql that any user
> can create a table in any database. Is there a way to restrict access
> to a database to specific users or groups. I see how to do this with a
> table after it has been created using GRANT and REVOKE, but I don't want
> to allow any user to be able to create tables in any database except the
> ones they have rights in.
Elkan --
AFAIK, there's no way to do this in current versions.
In 7.3 (in CVS now), you can grant/revoke CREATE capabilities, or limit
users to creating temporary tables only. Unless you're a masochist, it's too
early to run anything real in 7.3 now, but it'll be in real beta in a few
months.
- J.
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant