Re: Foreign tables - oracle_fdw - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Foreign tables - oracle_fdw
Date
Msg-id CAKFQuwbUQd1j5VZPSMHNhL+ie=fT51my8RVSmi40Cnat0BL1EQ@mail.gmail.com
Whole thread Raw
In response to Foreign tables - oracle_fdw  (Edwin UY <edwin.uy@gmail.com>)
List pgsql-admin
On Saturday, May 4, 2024, Edwin UY <edwin.uy@gmail.com> wrote:

Is it possible that as schema owner of either schema1 or schema2, i.e. administrator, I create the user mapping and the foreign tables and then grant access to user1 to user5 and schema2/schema1?
I can't find any reference/doc/example on whether this is possible or not.

I also don't have the password of each user. Can I use set role user1 to user5 to do the CREATE USER MAPPING and CREATE FOREIGN TABLE.

In summary, I am wanting to do the CREATE USER MAPPING and CREATE FOREIGN TABLE once only in either SCHEMA1 and SCHEMA2 and grant any role/user to be able to access these foreign tables, mainly just a select.

Any guidance will be much appreciated. Please advise. Thanks in advance.

 
I’m not really following the specifics but most likely appropriate usage of group roles will ease things.


Though letting users select from the foreign table is just a permissions thing.

David J.

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Foreign tables - oracle_fdw
Next
From: Laurenz Albe
Date:
Subject: Re: Foreign tables - oracle_fdw