To fetch the list of roles and the role owner you can use the below query:
SELECT role_name,role_owner FROM svv_roles;
Use SVV_RLS_POLICY to view a list of all row-level security policies created on the Amazon Redshift cluster.
SELECT * FROM svv_rls_policy;
Use SVV_RLS_RELATION to view a list of all relations that are RLS-protected. For example the below query should help you find the relation name, database name , schema name etc.
SELECT datname, relschema, relname, relkind, is_rls_on FROM svv_rls_relation ORDER BY relname;
Below are some links which would help you understand more about the tables & their respective columns.
restoring redshift serverless from provisioned cluster snapshotasked 7 months ago
Roles defined in Redshiftasked 2 months ago
Private Redshift cluster connectivity from tableau webasked 8 months ago
Redshift ML / SageMaker - Deploy an existing model artifact to a Redshift ClusterAccepted Answerasked 2 years ago
Redshift Disaster Recovery, attempting to restore tables to cluster in another account.asked 4 months ago
Restoring Redshift Cluster from Snapshot fails. You do not have access to node type.asked 4 months ago
Redshift cluster stuck on "resuming" for several hours, what options are available?asked 7 months ago
I can't stop/close my redshift clusterAccepted Answerasked a year ago
Change cluster parameter groupAccepted Answerasked 3 years ago
DMS CDC to Redshift during cluster resizeAccepted Answerasked 2 years ago