alter default privileges problem

Поиск
Список
Период
Сортировка
Искать
От
Gauthier, Dave
Тема
alter default privileges problem
Дата
Msg-id
0AD01C53605506449BA127FB8B99E5E13E11E575@FMSMSX105.amr.corp.intel.com
Список
Дерево обсуждения
alter default privileges problem "Gauthier, Dave" <dave.gauthier@intel.com>
Re: alter default privileges problem "Gauthier, Dave" <dave.gauthier@intel.com>
Re: alter default privileges problem Tom Lane <tgl@sss.pgh.pa.us>

v9.1 on linux

 

Connect to postgres DB, then...

 

create user "select" password 'select';

create user "insert" password 'insert';

alter default privileges for user "insert" grant select on tables to "select";

alter default privileges for user "insert" grant select on sequences to "select";

alter default privileges for user "insert" grant execute on functions to "select";

 

Disconnect.  Reconnect as user "insert", then...

 

create table foo (a text);

insert into foo (a) values ('aaa');

 

Disconnect.  Reconnect as user "select", expecting to be able to select contents of the "foo" table, but fails with "permission denied for relation foo".

 

Bottom line is that I want the "select" user to be able to query any table, sequence or use any function created by user "insert".

 

Thanks for any help !

 

В списке pgsql-general по дате отправления
От: Robert Klaus
Дата:
От: Jerry Sievers
Дата:
FAQ