sp_alter_secure_feature_key(
name
, auth_key
, features
)

This procedure allows you to alter the authorization key or feature list of an existing secure feature key.

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

None

• Creating secure feature keys
• sp_create_secure_feature_key system procedure
• sp_drop_secure_feature_key system procedure
• sp_list_secure_feature_keys system procedure
• sp_use_secure_feature_key system procedure
• List of secure features: -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, creates a new secure feature key called MYSET with case-sensitive authorization key securemyset, alters which secure features belong to the set, and then uses sp_list_secure_feature_keys to obtain a list of the currently defined secure feature keys:

CALL sp_use_secure_feature_key( 'system', 'securefkey' );
CALL sp_create_secure_feature_key( 'myset', 'securemyset', 'local' );
CALL sp_alter_secure_feature_key( 'myset', 'securemyset', 'local,remote' );
CALL sp_list_secure_feature_keys( );