From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | alter default privileges problem |
Date: | 2013-01-03 19:09:10 |
Message-ID: | 0AD01C53605506449BA127FB8B99E5E13E11E575@FMSMSX105.amr.corp.intel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 !
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2013-01-03 19:15:19 | Re: [ADMIN] Unable to reload postgresql.conf without restarting |
Previous Message | Matheus de Oliveira | 2013-01-03 18:34:04 | Re: Unable to reload postgresql.conf without restarting |