Database Rights
Hi,
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.
Thanks for any help,
-Elkan
-----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 RightsI 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