sp_drop_secure_feature_key system procedure

Deletes a secured feature key.

Syntax

sp_drop_secure_feature_key( name )

Parameters

name
The VARCHAR (128) name of the secured feature key to drop.

Remarks

You must have the MANAGE_KEYS feature enabled on the connection to run this procedure.

If the named key does not exist, an error is returned. If the named key exists, it is deleted as long as it is not the last secured feature key that is allowed to manage features and secured feature keys. The SYSTEM secured feature key cannot be dropped unless there is another key that has the MANAGE_FEATURES and MANAGE_KEYS features enabled.

Privileges

You must have EXECUTE privilege on the system procedure, as well as the SERVER OPERATOR system privilege.

Side effects

None

Example

In order for the following example to work, the server must be started with the option: -sk securefkey.

This example enables the SYSTEM secured feature key which includes MANAGE_KEYS and then drops the secured feature key called MYSET:

CALL sp_use_secure_feature_key( 'system', 'securefkey' );
CALL sp_drop_secure_feature_key( 'myset' );