Re: Owner of schema cant access foreign tables in that schema

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

 



Hi,
so what exactly authirzation grants you ? allowing the owner of the schema change properties of the tables ? allowing the owner of the schema grant permissions on the tables in that schema ?
I tried to query with my user (mariel) a table in a schema that is owned by my user but I couldnt query that table because of lack of permissions.

‫בתאריך יום א׳, 30 בספט׳ 2018 ב-11:11 מאת ‪David G. Johnston‬‏ <‪david.g.johnston@xxxxxxxxx‬‏>:‬
On Sunday, September 30, 2018, Mariel Cherkassky <mariel.cherkassky@xxxxxxxxx> wrote:
It suppose to mean that all objects that will be created in the sqlite_foreign_Schema db will be owned by the user mariel.

Authorization does not “mean that”: ownership of a schema has no bearing on ownership of contained objects.  Your questions boil down to this misunderstanding.

David J.


[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