User postgres unable to revoke privileges?

Поиск
Список
Период
Сортировка
От François Beausoleil
Тема User postgres unable to revoke privileges?
Дата
Msg-id F411D60E-2A39-4112-A530-7EDF174DD509@teksol.info
обсуждение исходный текст
Ответы Re: User postgres unable to revoke privileges?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi all!

I would like to remove the second line from default privileges, because dataanalysts can't create new tables in public
anyway:

# psql -U postgres
psql (9.1.9)
Type "help" for help.

regress=# \ddp
                        Default access privileges
    Owner     |    Schema    | Type  |         Access privileges
--------------+--------------+-------+-----------------------------------
 dataanalysts | dataanalysts | table | dataanalysts=arwdDxt/dataanalysts
 dataanalysts | public       | table | dataanalysts=r/dataanalysts
 svanalytics  | public       | table | dataanalysts=r/svanalytics
(3 rows)

regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public REVOKE SELECT ON TABLES FROM dataanalysts;
ERROR:  permission denied for schema public

I'm logged in as postgres, the database superuser. Why am I getting a permission denied?

Thanks!
François Beausoleil


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: David Johnston
Дата:
Сообщение: Re: Function use in query
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Streaming replication with sync slave, but disconnects due to missing WAL segments