Re: Fw: DB and Table Permissions
От | Dan Wilson |
---|---|
Тема | Re: Fw: DB and Table Permissions |
Дата | |
Msg-id | 006301c0563c$68cdacf0$078353d8@danwilson обсуждение исходный текст |
Ответ на | Fw: DB and Table Permissions ("Dan Wilson" <phpPgAdmin@acucore.com>) |
Список | pgsql-hackers |
> > ----- Original Message ----- > > From: "Dan Wilson" <phpPgAdmin@acucore.com> > > To: "pgsql general" <pgsql-general@postgresql.org> > > Sent: Sunday, November 19, 2000 9:33 AM > > Subject: DB and Table Permissions > > > > > Is there a reason why _any_ user can create a table on a database? Even if > > > they do not own or have any permissions to it? > > > > > > I don't think that should happen. Is there a specific reason why it does? > > Well, you should be able to do "GRANT ..." statements against the pg_... > tables to control this if you want to. > > Cheers, > Andrew. Using GRANT and REVOKE statements doesn't help because the permissions are attached to the table, not the database. So any user can create a new table within a database even if they are not the owner. I think this needs to be corrected somehow. -Dan
В списке pgsql-hackers по дате отправления: