Re: Database Rights

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of webmaster
> Sent: Tuesday, May 28, 2002 9:03 AM
> To: pgsql-general(at)postgresql(dot)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(at)joelburton(dot)com | joelburton.com | aim: wjoelburton
Knowledge Management & Technology Consultant