> > > On Tue, 25 Mar 2008 09:54:20 -0500 > > > "Roberts, Jon" <[EMAIL PROTECTED]> wrote: > > > > > > > I have some users that need "select any table" but they should not > > be > > > > superusers. How can this be done? > > > > > > > > I need a "grant select on <dbname> to <rolename>". > > > > > > You can't do it with a single command. It is easy enough to write a > > > query to grab the tables and grant select on them though. > > > > > > > We are adding tables and schemas all of the time and we need to grant > > auditors read-only access to the database. > > > > O.k. :) but that doesn't change my response. You can't do it with a > single command. You can script it. > >
It would be a nice enhancement to have a "select any table" privilege or at least "grant insert/update/delete/select on <schema_name>". Jon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
