sp_alter_secure_feature_key system procedure

Alters a previously defined secured feature key by modifying the authorization code and/or feature list.

Syntax

sp_alter_secure_feature_key(
name
, auth_key
, features
)

Parameters

name
The VARCHAR (128) name for the secured feature key you want to alter. A key with the given name must already exist.
auth_key
The CHAR (128) case-sensitive new authorization code for the secured feature key. The authorization code must be either a non-empty string of at least six characters, or NULL, indicating that the existing authorization code is not to be changed.
features
The LONG VARCHAR, comma-separated list of features that the key can enable. If features is NULL, the existing feature set is not changed.

Remarks

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

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

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, creates a new secured feature key called MYSET with case-sensitive authorization code SecureMySet, alters which secured features belong to the set, and then uses sp_list_secure_feature_keys to obtain a list of the currently defined secured 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', NULL, 'local,remote' );
CALL sp_list_secure_feature_keys( );