On Sat, Dec 5, 2009 at 3:46 PM, Guillaume Lelarge
> 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.
I completely missed that in the docs. Thanks for the catch.
In response to
pgsql-admin by date
|Next:||From: Adam Tucker||Date: 2009-12-07 18:29:18|
|Subject: Question about replication options |
|Previous:||From: Guillaume Lelarge||Date: 2009-12-05 22:46:03|
|Subject: Re: Help me understanding the schema|