docs/sql-manual/sql-statements/data-governance/DROP-ROW-POLICY.md

---
{
    "title": "DROP ROW POLICY",
    "language": "en",
    "description": "Delete row security policy. For details about row security policies, please refer to the \"Security Policies\" chapter"
}
---

## Description

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


## Syntax

```sql
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*

  ```sql
  DROP ROW POLICY policy1 ON db1.table1
  ```

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

  ```sql
  DROP ROW POLICY policy1 ON db1.table1 FOR user1
  ```

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

  ```sql
  DROP ROW POLICY policy1 ON db1.table1 FOR role role1
  ```