1 Antwort
- Neueste
- Die meisten Stimmen
- Die meisten Kommentare
3
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.
https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_RLS_RELATION.html
https://docs.aws.amazon.com/redshift/latest/dg/r_SVV_RLS_POLICY.html
https://docs.amazonaws.cn/en_us/redshift/latest/dg/r_SVV_ROLES.html
Relevanter Inhalt
- AWS OFFICIALAktualisiert vor 4 Monaten
- AWS OFFICIALAktualisiert vor 3 Jahren
- AWS OFFICIALAktualisiert vor 2 Jahren
- AWS OFFICIALAktualisiert vor einem Jahr