Re: deny table creation
От | Joel Burton |
---|---|
Тема | Re: deny table creation |
Дата | |
Msg-id | 004f01c21091$b2eb69b0$63eebed1@jburtonsat3005 обсуждение исходный текст |
Ответ на | deny table creation ("M.L.Bowman" <M.L.Bowman@ukc.ac.uk>) |
Список | pgsql-general |
Control over table creation (in a database or in a particular schema) will be in 7.3 (now in CVS) via traditional GRANT/REVOKE statements. AFAIK, there's no way to prevent it in PG ver < 7.3. - J. -- Joel BURTON | joel@joelburton | www.joelburton.com | aim:wjoelburton Information Technology & Knowledge Management Consultant > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org]On Behalf Of M.L.Bowman > Sent: Friday, June 07, 2002 12:47 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] deny table creation > > > Hello, > > I am trying to deny the ability to create tables in a database to > all users except the database owner and the superuser. > > As superuser, I have attempted to revoke insert/update/delete/rules > permissions to users on pg_class and pg_tables, but to no avail. It > would appear that the read/insert/update permissions on these two > relations are fixed. Users are always able to create tables. Yet when > I try to display the permissions I get > > \z pg_class > Access privileges for database "cswdb" > Table | Access privileges > -------+------------------- > (0 rows) > > \z pg_tables > Access privileges for database "cswdb" > Table | Access privileges > -------+------------------- > (0 rows) > > Is it the superuser who is updating these tables via Rules rather > than the current user? > > Can any-one suggest an alternative approach to preventing users > from creating tables? > > Thanks > Maggie Bowman > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >
В списке pgsql-general по дате отправления: