Re: select any table

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 25 Mar 2008 10:16:19 -0500
"Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> wrote:

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

O.k. :) but that doesn't change my response. You can't do it with a
single command. You can script it.

http://pgedit.com/public/sql/acl_admin/index.html
http://unf.be/postgresql/postgres_grant_all.perl
http://www.archonet.com/pgdocs/grant-all.html

There are some links that may help you.

Sincerely,

Joshua D. Drake

>
> Jon
>

- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH6T4TATb/zqfZUUQRAseZAJ4zR3NhBoNbwrbjNaTIdLR0UFOuhwCbBT3D
NgEqYHc68KKhWnks5g8vrW0=
=7R0w
-----END PGP SIGNATURE-----