Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Deletes a secured feature key.
sp_drop_secure_feature_key( name )
The VARCHAR (128) name of the secured feature key to drop.
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.
You must have EXECUTE privilege on the system procedure, as well as the SERVER OPERATOR system privilege.
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' );