On Wed, Dec 5, 2012 at 7:02 AM, Gauthier, Dave <dave.gauthier@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