SVV_ROLES

Use SVV_ROLES to view role information.

This table is visible to all users.

Table columns

Column name	Data type	Description
role_id	integer	The role ID.
role_name	text	The name of the role.
role_owner	text	The name of the role owner.
external_id	text	The unique identifier of the role in the third-party identity provider.

Sample query

The following example returns the output of SVV_ROLES.

SELECT role_name,role_owner FROM svv_roles WHERE role_name IN ('role1', 'role2');

 role_name | role_owner
-----------+------------
   role1   | superuser
   role2   | superuser