| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | "Andy Shellam (Mailing Lists)" <andy-lists(at)networkmail(dot)eu>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Kiswono Prayogo <kiswono(at)gmail(dot)com> |
| Subject: | Re: Help me understanding the schema |
| Date: | 2009-12-05 22:46:03 |
| Message-ID: | 200912052346.03417.guillaume@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Le samedi 5 décembre 2009 à 23:08:58, Andy Shellam (Mailing Lists) a écrit :
> Hi Scott,
>
> >> 7. we can set the privilege of user x for schema y
> >> ie. database aaa contains schema a1, a2 and a3. user xx can query from
> >> schema a1 only, user yy can query from schema a2 only?
> >
> > No, perms on schemas control schema actions like create. perms on
> > tables control user access.
>
> I thought that a user also had to have the USAGE right on a schema? In an
> application I'm working on at the moment, it threw the error "permission
> denied on schema xxx" even if permissions on the tables within the schema
> were OK - I had to assign the USAGE right on the schema.
>
You're right. One needs USAGE right to use the schema, and CREATE right to
create objects in this schema.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-12-05 23:15:13 | Re: Help me understanding the schema |
| Previous Message | Andy Shellam (Mailing Lists) | 2009-12-05 22:08:58 | Re: Help me understanding the schema |