# DROP SECURITY INTEGRATION

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
DROP SECURITY INTEGRATION security_integration_name;
```

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

Drops a security integration from the organization. Only a role with the MANAGE\_MEMBERS privilege can drop a security integration.

### Arguments

#### **security\_integration\_name**

Specifies the name of the new security integration. 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>

#### Drop a security integration

The following drops the security integration named `okta`:

```shell
<no-db>/<no-store># LIST SECURITY INTEGRATIONS;
+-------+-------+-------------------------------+-------------------------------+
|  Name |  Type |  Created At                   |  Updated At                   |
+=======+=======+===============================+===============================+
| okta  | scim  | 2024-07-15 23:17:14 +0000 UTC | 2024-07-15 23:17:14 +0000 UTC |
+-------+-------+-------------------------------+-------------------------------+
<no-db>/<no-store># DROP SECURITY INTEGRATION "okta";
+----------------------+------------+------------+------------------------------------------+
|  Type                |  Name      |  Command   |  Summary                                 |
+======================+============+============+==========================================+
| security integration | okta       | DROP       | security integration okta was            |
|                      |            |            | successfully dropped                     |
+----------------------+------------+------------+------------------------------------------+
```