deny table creation
От | M.L.Bowman |
---|---|
Тема | deny table creation |
Дата | |
Msg-id | E17GMtV-0000h7-00@myrtle.ukc.ac.uk обсуждение исходный текст |
Ответы |
Re: deny table creation
Re: deny table creation Re: deny table creation |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: