DROP ROW POLICY

Description

Delete row security policy. For details about row security policies, please refer to the "Security Policies" chapter

Syntax

DROP ROW POLICY <policy_name> on <table_name>
  [ FOR { <user_name> | ROLE <role_name> } ];

Required Parameters

<policy_name>

Row security policy name

<table_name>

Table name

Optional Parameters (Optional Parameters)

<user_name>

User name

<role_name>

Role name

Access Control Requirements (Access Control Requirements)

The user executing this SQL command must have at least the following privileges:

Privilege	Object	Notes
ADMIN_PRIV or GRANT_PRIV	Global

Examples (Examples)

1. Delete the policy1 row security policy for db1.table1

DROP ROW POLICY policy1 ON db1.table1

1. Delete the policy1 row security policy for db1.table1 that applies to user1

DROP ROW POLICY policy1 ON db1.table1 FOR user1

1. Delete the policy1 row security policy for db1.table1 that applies to role1

DROP ROW POLICY policy1 ON db1.table1 FOR role role1