PG_RLSPOLICIES
PG_RLSPOLICIES contains row-level access control 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 access control policy is applied |
tablename |
name |
Name of the table object to which the row-level access control policy is applied |
policyname |
name |
Name of the row-level access control policy |
policypermissive |
text |
Attribute of the row-level access control policy |
policyroles |
name[] |
List of users affected by the row-level access control policy. If this parameter is not specified, all users are affected. |
policycmd |
text |
SQL operations affected by the row-level access control policy |
policyqual |
text |
Expression of the row-level access control policy |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot