DROP ROW LEVEL SECURITY POLICY

Deletes a row-level access control policy from a table.

Only the table owner or administrators can delete a row-level access control policy from the table.

 DROP [ ROW LEVEL SECURITY ] POLICY [ IF EXISTS ] policy_name ON table_name [ CASCADE | RESTRICT ]
 

**Table 1** DROP ROW LEVEL SECURITY POLICY parameters
Parameter	Description	Value Range
IF EXISTS	Reports a notice instead of an error if the specified row-level access control policy does not exist.	-
policy_name	Specifies the name of a row-level access control policy to be deleted.	An existing name of a row-level access control policy.
table_name	Specifies the name of a table to which a row-level access control policy to be deleted belongs.	An existing name of the data table to which a row-level access control policy belongs.
CASCADE/RESTRICT	The two parameters are used only for syntax compatibility. No objects depend on access control policies and thereby CASCADE is equivalent to RESTRICT.	-

Delete the row-level access control policy all_data_rls from table all_data.

 DROP ROW LEVEL SECURITY POLICY all_data_rls ON all_data;
 

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.