Drop Application Identity

Use the DROP APPLICATION IDENTITY command to remove an application identity from the database.

Required privilege

The DROP APPLICATION IDENTITY system privilege.

Syntax

DROP APPLICATION IDENTITY [ IF EXISTS ] app_identity;

Parameters

Parameter	Description
app_identity	The name of the application identity to be dropped.

Usage notes and restrictions

• When IF EXISTS is specified:

  • If the application identity does not exist, the statement is a no-op. No error is raised.

  • If the application identity exists, it is dropped.

• When IF EXISTS is omitted:

  • If the application identity does not exist, an error is raised.

  • If the application identity exists, it is dropped.

For syntax diagrams and additional details, see DROP APPLICATION IDENTITY in Oracle AI Database SQL Language Reference.

Example: Drop application identity

Drop the application identity for the HCM application.

DROP APPLICATION IDENTITY hcm_app;