From: | "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: select any table |
Date: | 2008-03-25 18:37:37 |
Message-ID: | 1A6E6D554222284AB25ABE3229A92762E9A027@nrtexcus702.int.asurion.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> > > 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.
>
>
It would be a nice enhancement to have a "select any table" privilege or
at least "grant insert/update/delete/select on <schema_name>".
Jon
From | Date | Subject | |
---|---|---|---|
Next Message | srdjan | 2008-03-25 18:40:26 | RULES and QUALIFICATION for INSERT |
Previous Message | Andrus | 2008-03-25 18:35:55 | Triggers are disabled after restore |