sp_drop_secure_feature_key( name )

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 secure feature key that is allowed to manage secure features and secure feature keys. The SYSTEM secure feature key cannot be dropped unless there is another key that has the MANAGE_FEATURES and MANAGE_KEYS secure features enabled.

You must have the SERVER OPERATOR system privilege and have the MANAGE_KEYS feature enabled on the connection.

None

• Creating secure feature keys
• sp_alter_secure_feature_key system procedure
• sp_create_secure_feature_key system procedure
• sp_list_secure_feature_keys system procedure
• sp_use_secure_feature_key system procedure
• MANAGE_FEATURES and MANAGE_KEYS: -sf database server option

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

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

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