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
|
| Список | 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 по дате отправления: