Re: select any table

> On Tue, 25 Mar 2008 09:54:20 -0500
> "Roberts, Jon" <Jon.Roberts@asurion.com> 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