| From: | "Chris Ochs" <chris(at)paymentonline(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Grant / Revoke functionality |
| Date: | 2004-06-04 05:50:06 |
| Message-ID: | 022701c449f7$ca4f4940$239b2904@chris2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Wed, 18 Feb 2004, Shridhar Daithankar wrote:
>
> > On Wednesday 18 February 2004 13:38, Alexander Priem wrote:
> > > Is there a way in which I can give rights to a user for a set of
> > > tables/views/sequences WITHOUT having to name all of the
> > > table/view/sequence names?
> >
> > You can use schemas. Just put everything under schema and grant user
> > rights to the schema...
> >
>
> This is not accurate. The only schema level permissions are CREATE and
> USAGE they are independent of the permissions on the objects contained
> within. He would still need to grant access to the underlying objects.
>
> Kris Jurka
>
If you need to do this for a lot of users use group permissions, it's a lot
easier to manage.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Klawitter | 2004-06-04 06:07:51 | Re: Disappointing news |
| Previous Message | Greg Stark | 2004-06-04 05:31:05 | Bug Report -- information schema view is broken 'unrecognized privilege type: "RERERENCES"' |