Information schema for object_privileges

You can use the information_schema.object_privileges view to return information about permissions granted to each role.
You can use a SELECT query to return information about each privilege as shown in the example below.

SELECT
  *
FROM
  information_schema.object_privileges;

Read more about RBAC privileges here.

Columns in information_schema.object_privileges

Each row has the following columns with information about the role.

Column Name Data Type Description
grantor TEXT Name of the user that granted the privilege.
grantee TEXT Name of the role that the privilege was granted to (TO ROLE).
object_catalog TEXT Database containing the object on which the privilege is granted.
object_schema TEXT Schema containing the object on which the privilege is granted.
object_name TEXT Name of the object on which the privilege is granted.
object_type TEXT Type of the object on which the privilege is granted.
privilege_type TEXT Type of the privilege granted over the object.
is_grantable TEXT YES if the privilege is grantable, NO if not.
created TIMESTAMPTZ Creation time of the privilege.