DROP-MATERIALIZED-VIEW
DROP-POLICY
Name
DROP POLICY
Description
drop policy for row or storage
ROW POLICY
Grammar:
- Drop row policy
DROP ROW POLICY test_row_policy_1 on table1 [FOR user| ROLE role];
- Drop storage policy
DROP STORAGE POLICY policy_name1
Example
-
Drop the row policy for table1 named test_row_policy_1
DROP ROW POLICY test_row_policy_1 on table1
-
Drop the row policy for table1 using by user test
DROP ROW POLICY test_row_policy_1 on table1 for test
-
Drop the row policy for table1 using by role1
DROP ROW POLICY test_row_policy_1 on table1 for role role1
-
Drop the storage policy named policy_name1
DROP STORAGE POLICY policy_name1
Keywords
DROP, POLICY