|
The fix had to do with connecting as the "insert" user, then setting the default privs. My mistake was to run the "alter default privileges..." as the superuser. From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]
On Behalf Of Gauthier, Dave 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 ! |
