Properties

Name: administrable_role_authorizations 
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 administrable_role_authorizations AS
    SELECT applicable_roles.grantee, applicable_roles.role_name, applicable_roles.is_grantable FROM applicable_roles WHERE ((applicable_roles.is_grantable)::text = 'YES'::text);


ALTER TABLE information_schema.administrable_role_authorizations OWNER TO postgres;

See Also

List of views