dblink_connect grant privelages on foreign db table

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема dblink_connect grant privelages on foreign db table
Дата
Msg-id 159975162317.19777.1869528586555716998@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/contrib-dblink-connect.html
Description:

In this section of dblink_connect
```
CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw OPTIONS (hostaddr
'127.0.0.1', dbname 'contrib_regression');

CREATE USER regress_dblink_user WITH PASSWORD 'secret';
CREATE USER MAPPING FOR regress_dblink_user SERVER fdtest OPTIONS (user
'regress_dblink_user', password 'secret');
GRANT USAGE ON FOREIGN SERVER fdtest TO regress_dblink_user;
GRANT SELECT ON TABLE foo TO regress_dblink_user;

\set ORIGINAL_USER :USER
\c - regress_dblink_user
SELECT dblink_connect('myconn', 'fdtest');
 dblink_connect 
----------------
 OK
(1 row)

SELECT * FROM dblink('myconn','SELECT * FROM foo') AS t(a int, b text, c
text[]); ```

The GRANT SELECT seemingly attempts to give a local user permissions on a
table in a foreign db. This results in an error:
 ``` relation 'foo' does not exist ```

I would like to be able to local permissions on a user's ability to access
foreign tables, but this does not seem correct.

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: typo in literature reference
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Additional Chapter for Tutorial