OSDN Git Service

Remove partial and undocumented GRANT .. FOREIGN TABLE support.
authorRobert Haas <rhaas@postgresql.org>
Mon, 25 Apr 2011 20:34:57 +0000 (16:34 -0400)
committerRobert Haas <rhaas@postgresql.org>
Mon, 25 Apr 2011 20:39:18 +0000 (16:39 -0400)
commitbe90032e0d1cf473bdd99aee94218218f59f29f1
tree1e9d72a479c35cc2485b6049341fae25525c05d5
parentaf0f20092c8662bf7610fab07b8a1e354abba67f
Remove partial and undocumented GRANT .. FOREIGN TABLE support.

Instead, foreign tables are treated just like views: permissions can
be granted using GRANT privilege ON [TABLE] foreign_table_name TO role,
and revoked similarly.  GRANT/REVOKE .. FOREIGN TABLE is no longer
supported, just as we don't support GRANT/REVOKE .. VIEW.  The set of
accepted permissions for foreign tables is now identical to the set for
regular tables, and views.

Per report from Thom Brown, and subsequent discussion.
doc/src/sgml/ref/grant.sgml
src/backend/catalog/aclchk.c
src/backend/parser/gram.y
src/backend/utils/adt/acl.c
src/include/nodes/parsenodes.h
src/include/utils/acl.h