Re: how do I grant select to one user for all tables in a DB? - Mailing list pgsql-general

From Jeff Janes
Subject Re: how do I grant select to one user for all tables in a DB?
Date
Msg-id CAMkU=1wcm3ODzCB0mku6+K165shHhvCZsK9G-dxM3_QwrmCMhg@mail.gmail.com
Whole thread Raw
In response to Re: how do I grant select to one user for all tables in a DB?  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: icholy
Date:
Subject: libpq - prevent automatic reconnect
Next
From: "James Cowell"
Date:
Subject: Re: Corrupt indexes on slave when using pg_bulkload on master