`custom_classifier`!DELETE_CATEGORY¶

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

Syntax¶

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

Copy

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

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

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.

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

For a representative example, see the custom classification example.