Properties

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

Columns

Name Type Length
  grantor  sql_identifier  -1 
  grantee  sql_identifier  -1 
  object_catalog  sql_identifier  -1 
  object_schema  sql_identifier  -1 
  object_name  sql_identifier  -1 
  object_type  character_data  -1 
  privilege_type  character_data  -1 
  is_grantable  character_data  -1 
Total: 8 column(s)

SQL


CREATE VIEW role_usage_grants AS
    SELECT (NULL::character varying)::sql_identifier AS grantor, (NULL::character varying)::sql_identifier AS grantee, (current_database())::sql_identifier AS object_catalog, (NULL::character varying)::sql_identifier AS object_schema, (NULL::character varying)::sql_identifier AS object_name, (NULL::character varying)::character_data AS object_type, ('USAGE'::character varying)::character_data AS privilege_type, (NULL::character varying)::character_data AS is_grantable WHERE false;


ALTER TABLE information_schema.role_usage_grants OWNER TO postgres;

See Also

List of views