DROP ROW LEVEL SECURITY POLICY
Function
DROP ROW LEVEL SECURITY POLICY deletes a specified row-level access control policy on a table.
Precautions
Only the table owner or an administrator can execute DROP ROW LEVEL SECURITY POLICY.
Syntax
1 | DROP [ ROW LEVEL SECURITY ] POLICY [ IF EXISTS ] policy_name ON table_name [ CASCADE | RESTRICT ] |
Parameter Description
| Parameter | Description | Value Range |
|---|---|---|
| IF EXISTS | If the specified row-level access control policy does not exist, a notice is issued instead of throwing an error. | - |
| policy_name | Specifies the name of the row-level access control policy to be deleted. | Name of an existing row-level access control policy. |
| table_name | Specifies the name of the data table on which the row-level access control policy to be deleted resides. | Name of the data table on which an existing row-level access control policy resides. |
| CASCADE/RESTRICT | This syntax is provided only for compatibility. No objects depend on the row-level access control policy, so CASCADE and RESTRICT have the same effect. | - |
Examples
Delete the row-level access control policy all_data_rls on table all_data.
1 | DROP ROW LEVEL SECURITY POLICY all_data_rls ON all_data; |
Helpful Links
ALTER ROW LEVEL SECURITY POLICY, CREATE 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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
