Re: Help me understanding the schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux