# DROP ROLE

## Syntax

```sql
DROP ROLE role_name;
```

## Description <a href="#description" id="description"></a>

Drops a [custom role](https://docs.deltastream.io/overview/core-concepts/access-control#custom-roles) within the [organization](https://docs.deltastream.io/overview/core-concepts/access-control#_organiation).

{% hint style="info" %}
**Note** You cannot drop [built-in roles](https://docs.deltastream.io/overview/core-concepts/access-control#built-in-roles).
{% endhint %}

There are guidelines for dropping custom roles:

* Only the owner of a role, or a role with [MANAGE\_MEMBERS](https://docs.deltastream.io/overview/core-concepts/access-control#available-privileges), can drop a role.
* You cannot drop any role that is the owner of an object. If you do wish drop such a role, you must first transfer ownership of the object (or objects) from the role you wish to drop to a role you intend to keep. To transfer ownership of an object, use [grant-ownership](https://docs.deltastream.io/reference/sql-syntax/command/grant-ownership "mention").
* You also cannot drop any role that has been granted any other roles. In this case, you must revoke any such granted roles first. To revoke any granted roles, use [revoke-role](https://docs.deltastream.io/reference/sql-syntax/command/revoke-role "mention").

### Arguments

#### role\_name

The name of the role to drop. If the name is case sensitive you must wrap it in double quotes; otherwise the system uses the lower case name.

## Examples <a href="#example" id="example"></a>

```sh
<no-db>/<no-store># DROP ROLE test_role;
+------------+------------+------------+------------------------------------------+
|  Type      |  Name      |  Command   |  Summary                                 |
+============+============+============+==========================================+
| role       | test_role  | DROP       | role "test_role" was successfully        |
|            |            |            | dropped                                  |
+------------+------------+------------+------------------------------------------+
```