`custom_classifier`!DELETE_CATEGORY¶

See also:: Using custom classifiers for sensitive data classification

Deletes the specified semantic category with its associated privacy category, regular expression, and comment from the instance.

Syntax¶

<custom_classifier>!DELETE_CATEGORY( '<semantic_category>' )

Copy

Arguments¶

semantic_category: Specifies the identifier (name) for the semantic category that you added to the instance when calling the custom_classifier!ADD_REGEX method.

Output¶

Returns a status message indicating the deletion of the specified semantic category.

Access control requirements¶

A role used to execute this SQL command must have the following privileges at a minimum:

Instance role	Object	Notes
`custom_classifier`!PRIVACY_USER	The custom classification instance.	The account role that calls this method must be granted this instance role on the custom classifier. By default, the account role used to create the instance can call this method.

Instance role

Object

Notes

custom_classifier!PRIVACY_USER

The custom classification instance.

The account role that calls this method must be granted this instance role on the custom classifier.

By default, the account role used to create the instance can call this method.

Note that operating on any object in a schema also requires the USAGE privilege on the parent database and schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes¶

Call the method in a separate SQL statement (no method chaining).

Examples¶

Delete a category from the medical_codes instance:

CALL medical_codes!DELETE_CATEGORY('IC_10_CODES');