1개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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
관련 콘텐츠
- AWS 공식업데이트됨 일 년 전