diff options
Diffstat (limited to 'contrib/file_fdw/input/file_fdw.source')
| -rw-r--r-- | contrib/file_fdw/input/file_fdw.source | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/contrib/file_fdw/input/file_fdw.source b/contrib/file_fdw/input/file_fdw.source index 416753dcada..35db4af0824 100644 --- a/contrib/file_fdw/input/file_fdw.source +++ b/contrib/file_fdw/input/file_fdw.source @@ -173,6 +173,9 @@ SET ROLE file_fdw_user; \t on EXPLAIN (VERBOSE, COSTS FALSE) SELECT * FROM agg_text WHERE a > 0; \t off +-- file FDW allows foreign tables to be accessed without user mapping +DROP USER MAPPING FOR file_fdw_user SERVER file_server; +SELECT * FROM agg_text ORDER BY a; -- privilege tests for object SET ROLE file_fdw_superuser; |