Show default privileges in information schema
Peter Eisentraut <peter_e@gmx.net>
Show default privileges in information schema Hitherto, the information schema only showed explicitly granted privileges that were visible in the *acl catalog columns. If no privileges had been granted, the implicit privileges were not shown. To fix that, add an SQL-accessible version of the acldefault() function, and use that inside the aclexplode() calls to substitute the catalog-specific default privilege set for null values. reviewed by Abhijit Menon-Sen
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/information_schema.sql | modified | +9 −9 |
| src/backend/utils/adt/acl.c | modified | +58 −0 |
| src/include/catalog/catversion.h | modified | +1 −1 |
| src/include/catalog/pg_proc.h | modified | +2 −0 |
| src/include/utils/acl.h | modified | +1 −0 |
| src/test/regress/expected/foreign_data.out | modified | +4 −4 |
| src/test/regress/sql/foreign_data.sql | modified | +4 −4 |