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

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(dot)g(dot)johnston(at)gmail(dot)com‬‏>:‬

> On Sunday, September 30, 2018, Mariel Cherkassky <
> mariel(dot)cherkassky(at)gmail(dot)com> 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.
>
>