Re: [GENERAL] Setting default privs for a user doesn't seem to work.

2012-12-07 Thread Albe Laurenz
Dave Gauthier wrote: > What's wrong with this picture. Trying (failing) to create a user called > "select" with default select > privs and nothing else. Demo below. Comments in red... > > sde=# alter default privileges for user "select" grant select on tables to > "select"; > ALTER DEFAULT PRI

Re: [GENERAL] Setting default privs for a user doesn't seem to work.

2012-12-06 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gauthier, Dave Sent: Thursday, December 06, 2012 5:27 PM To: pgsql-general Subject: [GENERAL] Setting default privs for a user doesn't seem to work. What's wrong with this pictur

[GENERAL] Setting default privs for a user doesn't seem to work.

2012-12-06 Thread Gauthier, Dave
What's wrong with this picture. Trying (failing) to create a user called "select" with default select privs and nothing else. Demo below. Comments in red... fcadsql7> psql sde psql (9.1.5) Type "help" for help. sde=# \du List of roles Role name |