DROP-POLICY

Name

DROP POLICY

Description

drop policy for row or storage

ROW POLICY

Grammar:

  1. Drop row policy
1. DROP ROW POLICY test_row_policy_1 on table1 [FOR user];
  1. Drop storage policy
1. DROP STORAGE POLICY policy_name1

Example

  1. Drop the row policy for table1 named test_row_policy_1

1. DROP ROW POLICY test_row_policy_1 on table1 2. Drop the row policy for table1 using by user test

1. DROP ROW POLICY test_row_policy_1 on table1 for test 3. Drop the storage policy named policy_name1

1. DROP STORAGE POLICY policy_name1

Keywords

1. DROP, POLICY

Best Practice