-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 25 Mar 2008 10:16:19 -0500 "Roberts, Jon" <Jon.Roberts@xxxxxxxxxxx> wrote: > > 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. > 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----- -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
