SVV_ROLE_GRANTS - Amazon Redshift
Table columnsSample query

SVV_ROLE_GRANTS

Use SVV_ROLE_GRANTS to view a list of roles that are explicitly granted roles in the cluster.

SVV_ROLE_GRANTS is visible to the following users:

  • Superusers

  • Users with the ACCESS SYSTEM TABLE permission

Other users can only see identities they have access to or own.

Table columns

Column name Data type Description
role_id integer The ID of the role.
role_name text The name of the role.
granted_role_id integer The ID for the granted role.
granted_role_name text The name for the granted role.

Sample query

The following example returns the output of SVV_ROLE_GRANTS.

GRANT ROLE role1 TO ROLE role2;
GRANT ROLE role2 TO ROLE role3;

SELECT role_name, granted_role_name FROM svv_role_grants;

 role_name |  granted_role_name
-----------+--------------------
   role2   |      role1
   role3   |      role2
(2 rows)