Re: Owner of schema cant access foreign tables in that schema - Mailing list pgsql-admin

From Mariel Cherkassky
Subject Re: Owner of schema cant access foreign tables in that schema
Date
Msg-id CA+t6e1kr5X39T_6DV6tsfGvnfdVBWM6kWXmuj5WsNoWd=1cLOQ@mail.gmail.com
Whole thread Raw
In response to Re: Owner of schema cant access foreign tables in that schema  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Owner of schema cant access foreign tables in that schema
List 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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Owner of schema cant access foreign tables in that schema
Next
From: soumitra bhandary
Date:
Subject: Re: Owner of schema cant access foreign tables in that schema