| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| 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 19:22:56 |
| Message-ID: | 47E95110.1030400@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 25/03/2008 14:54, Roberts, Jon 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>".
PgAdmin (www.pgadmin.org) has a handy "Grant Wizard" which will do this
for you in one go.
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Simard | 2008-03-25 19:24:47 | Re: Converting mysql "on update" to postgres "rule" |
| Previous Message | Ben | 2008-03-25 19:20:06 | Re: Converting mysql "on update" to postgres "rule" |