sp_create_secure_feature_key(
name
, auth_key
, features
)

This procedure creates a new secure feature key that can be given to any user. The SYSTEM secure feature key is created by using the -sk database server option.

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

None

• List of secure features: -sf database server option
• -sk database server option
• Creating secure feature keys
• sp_alter_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

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, 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_list_secure_feature_keys( );