From be90032e0d1cf473bdd99aee94218218f59f29f1 Mon Sep 17 00:00:00 2001 From: Robert Haas Date: Mon, 25 Apr 2011 16:34:57 -0400 Subject: 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. --- src/backend/parser/gram.y | 8 -------- 1 file changed, 8 deletions(-) (limited to 'src/backend/parser') diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index 1e4f8f698b3..933a1a2ff9f 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -5408,14 +5408,6 @@ privilege_target: n->objs = $3; $$ = n; } - | FOREIGN TABLE qualified_name_list - { - PrivTarget *n = (PrivTarget *) palloc(sizeof(PrivTarget)); - n->targtype = ACL_TARGET_OBJECT; - n->objtype = ACL_OBJECT_FOREIGN_TABLE; - n->objs = $3; - $$ = n; - } | FUNCTION function_with_argtypes_list { PrivTarget *n = (PrivTarget *) palloc(sizeof(PrivTarget)); -- cgit v1.2.3