> On Tue, 25 Mar 2008 09:54:20 -0500 > "Roberts, Jon" <Jon.Roberts@xxxxxxxxxxx> 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. Jon -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
