DROP AUTHENTICATION INTEGRATION
DROP AUTHENTICATION INTEGRATION drops an authentication integration.
Note:
Supported since VeloDB Enterprise 4.1.4.
Syntax
DROP AUTHENTICATION INTEGRATION [IF EXISTS] <integration_name>;
Required parameters
| Parameter | Description |
|---|---|
<integration_name> | Name of the integration to drop. |
Optional parameters
| Parameter | Description |
|---|---|
IF EXISTS | Suppresses the error if the integration does not exist. |
Access control requirements
The user executing this statement must have the following privilege, either directly or through a role:
| Privilege | Object | Description |
|---|---|---|
ADMIN_PRIV | User or role | Required to perform this operation. |
Usage notes
- Without
IF EXISTS, the statement returns an error if the integration does not exist. - You cannot drop an integration that still has an associated role mapping. First remove the mapping with DROP ROLE MAPPING.
Examples
Drop an integration:
DROP AUTHENTICATION INTEGRATION corp_oidc;
Drop an integration only if it exists:
DROP AUTHENTICATION INTEGRATION IF EXISTS corp_oidc;