Add pg_has_role() family of privilege inquiry functions modeled after the
Tom Lane <tgl@sss.pgh.pa.us>
Add pg_has_role() family of privilege inquiry functions modeled after the existing ones for object privileges. Update the information_schema for roles --- pg_has_role() makes this a whole lot easier, removing the need for most of the explicit joins with pg_user. The views should be a tad faster now, too. Stephen Frost and Tom Lane.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +27 −1 |
| src/backend/catalog/information_schema.sql | modified | +112 −126 |
| src/backend/utils/adt/acl.c | modified | +221 −1 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_proc.h | modified | +14 −1 |
| src/include/utils/builtins.h | modified | +7 −1 |