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.