| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: select any table |
| Date: | 2008-03-25 15:16:01 |
| Message-ID: | 20080325081601.4d49d824@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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.
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-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberts, Jon | 2008-03-25 15:16:19 | Re: select any table |
| Previous Message | Tom Lane | 2008-03-25 15:13:39 | Re: Client-requested cast mode to emulate Pg8.2 on v8.3 |