| From: | "Andy Shellam (Mailing Lists)" <andy-lists(at)networkmail(dot)eu> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Kiswono Prayogo <kiswono(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Help me understanding the schema |
| Date: | 2009-12-05 22:08:58 |
| Message-ID: | 018EAD66-E9EB-4551-92BC-48226C43E205@networkmail.eu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
Regards,
Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2009-12-05 22:46:03 | Re: Help me understanding the schema |
| Previous Message | Scott Marlowe | 2009-12-05 20:53:09 | Re: Help me understanding the schema |