Re: [GENERAL] alter default privileges problem

"Gauthier, Dave" writes: > 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 privi

Re: [GENERAL] alter default privileges problem

Dave Sent: Thursday, January 03, 2013 2:09 PM To: pgsql-general@postgresql.org Subject: [GENERAL] alter default privileges problem v9.1 on linux Connect to postgres DB, then... create user "select" password 'select'; create user "insert" password 'insert'

[GENERAL] alter default privileges problem

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 def