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

Поиск
Список
Период
Сортировка
От Mariel Cherkassky
Тема Re: Owner of schema cant access foreign tables in that schema
Дата
Msg-id CA+t6e1kr5X39T_6DV6tsfGvnfdVBWM6kWXmuj5WsNoWd=1cLOQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Owner of schema cant access foreign tables in that schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Owner of schema cant access foreign tables in that schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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@gmail.com‬‏>:‬
On Sunday, September 30, 2018, Mariel Cherkassky <mariel.cherkassky@gmail.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Owner of schema cant access foreign tables in that schema
Следующее
От: soumitra bhandary
Дата:
Сообщение: Re: Owner of schema cant access foreign tables in that schema