GS_RLSPOLICIES
GS_RLSPOLICIES displays information about row-level security policies. The initial user and users with the sysadmin attribute can view all policy information. Other users can view only the policy information in their own tables.
Name |
Type |
Description |
---|---|---|
schemaname |
name |
Name of the schema of the table object to which a row-level security policy is applied. |
tablename |
name |
Name of the table object to which the row-level security policy is applied. |
policyname |
name |
Name of a row-level security policy. |
policypermissive |
text |
Expression combination mode of a row-level security policy. The options are as follows:
|
policyroles |
name[] |
List of users affected by the row-level security policy. If this parameter is not specified, all users are affected. |
policycmd |
text |
SQL operations affected by a row-level security policy. |
policyqual |
text |
Expression of a row-level security policy. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.