Name: | applicable_roles |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
grantee | sql_identifier | -1 |
|
role_name | sql_identifier | -1 |
|
is_grantable | character_data | -1 |
CREATE VIEW applicable_roles AS
SELECT (a.rolname)::sql_identifier AS grantee, (b.rolname)::sql_identifier AS role_name, (CASE WHEN m.admin_option THEN 'YES'::text ELSE 'NO'::text END)::character_data AS is_grantable FROM ((pg_auth_members m JOIN pg_authid a ON ((m.member = a.oid))) JOIN pg_authid b ON ((m.roleid = b.oid))) WHERE pg_has_role(a.oid, 'USAGE'::text);
ALTER TABLE information_schema.applicable_roles OWNER TO postgres;
See Also
List of views