-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 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. Sincerely, Joshua D. Drake - -- 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) iD8DBQFH6Rc0ATb/zqfZUUQRAuXYAKCjVwoLHZLasWFGUM4JwOa82yohEgCfRyRo nkLbi/vImp7jA+bqZD1o4Jc= =vFAR -----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
