On Wed, Dec 5, 2012 at 7:02 AM, Gauthier, Dave <dave.gauth...@intel.com> wrote: > Actually, maybe it didn't work. What's wrong with this picture... > > > sde=# alter default privileges for user "select" grant select on tables to > "select";
Remove the 'for user "select"' What that does is make the default permissions apply only to tables created *by* the user "select". This is essentially a no-op, since the user that creates an object already has privs on those objects. In fact, this usage should probably generate a warning. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
