11.2 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 11-4 Drop application identity

Drop the application identity for the HCM application.

DROP APPLICATION IDENTITY hcm_app;