Skip to main content
Skip to main content

DROP-MATERIALIZED-VIEW

DROP-POLICY​

Name​

DROP POLICY

Description​

drop policy for row or storage

ROW POLICY​

Grammar:

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

Example​

  1. Drop the row policy for table1 named test_row_policy_1

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

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

DROP STORAGE POLICY policy_name1

Keywords​

DROP, POLICY

Best Practice​