diff options
| author | Robert Haas <rhaas@postgresql.org> | 2011-05-13 15:47:31 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2011-05-13 15:51:03 -0400 |
| commit | 9bb6d9795253bb521f81c626fea49a704a369ca9 (patch) | |
| tree | cce2147cee0d333659c83f2bfaebd7d28e942ca7 /src/backend | |
| parent | c5ab8425be07f6a866ce84dc03f87d6924421e72 (diff) | |
| download | postgresql-9bb6d9795253bb521f81c626fea49a704a369ca9.tar.gz postgresql-9bb6d9795253bb521f81c626fea49a704a369ca9.zip | |
More cleanup of FOREIGN TABLE permissions handling.
This commit fixes psql, pg_dump, and the information schema to be
consistent with the backend changes which I made as part of commit
be90032e0d1cf473bdd99aee94218218f59f29f1, and also includes a
related documentation tweak.
Shigeru Hanada, with slight adjustment.
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/information_schema.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/catalog/information_schema.sql b/src/backend/catalog/information_schema.sql index c623fb7e75c..452a0ead44c 100644 --- a/src/backend/catalog/information_schema.sql +++ b/src/backend/catalog/information_schema.sql @@ -2557,8 +2557,8 @@ CREATE VIEW _pg_foreign_tables AS WHERE w.oid = s.srvfdw AND u.oid = c.relowner AND (pg_has_role(c.relowner, 'USAGE') - OR has_table_privilege(c.oid, 'SELECT') - OR has_any_column_privilege(c.oid, 'SELECT')) + OR has_table_privilege(c.oid, 'SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER') + OR has_any_column_privilege(c.oid, 'SELECT, INSERT, UPDATE, REFERENCES')) AND n.oid = c.relnamespace AND c.oid = t.ftrelid AND c.relkind = 'f' |