Re: Database Rights
От | Joel Burton |
---|---|
Тема | Re: Database Rights |
Дата | |
Msg-id | JGEPJNMCKODMDHGOBKDNEELNCPAA.joel@joelburton.com обсуждение исходный текст |
Ответ на | Database Rights (webmaster <webmaster@harbornet.com>) |
Список | pgsql-general |
> -----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
В списке pgsql-general по дате отправления: