Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » System procedures » Alphabetical list of system procedures

sp_alter_secure_feature_key system procedure

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

, auth_key
, features
  • 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.


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.


You must have EXECUTE privilege on the system procedure, as well as the SERVER OPERATOR system privilege.

Side effects



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