| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net> |
| Cc: | Alexander Priem <ap(at)cict(dot)nl>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Grant / Revoke functionality |
| Date: | 2004-02-19 05:35:33 |
| Message-ID: | Pine.LNX.4.33.0402190033160.3059-100000@leary.csoft.net |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-19 06:34:46 | Re: Grant / Revoke functionality |
| Previous Message | Tom Lane | 2004-02-19 04:43:00 | Re: cannot use createlang after removing public schema |