Properties

Name: applicable_roles 
Owner: postgres 
Has rules:  
Has Triggers:  
Comment:  

Columns

Name Type Length
  grantee  sql_identifier  -1 
  role_name  sql_identifier  -1 
  is_grantable  character_data  -1 
Total: 3 column(s)

SQL


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