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_list_secure_feature_keys system procedure

Returns a list of defined secured feature keys.

sp_list_secure_feature_keys( )
Result set
Column name Data type Description
name VARCHAR(128) The name of the secured feature key.
features LONG VARCHAR The secured features enabled by the secured feature key.

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

This procedures returns the names of existing secured feature keys, as well as the set of features that can be enabled by each key.

If the user has the MANAGE_FEATURES and MANAGE_KEYS features enabled, then the procedure returns a list of all secured feature keys.

If the user only has the MANAGE_KEYS feature enabled, then the procedure returns keys that have the same features or a subset of the same features that the current user has enabled.


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 the MANAGE_FEATURES and MANAGE_KEYS features, and then uses sp_list_secure_feature_keys to obtain a list of all the current secured feature keys:

CALL sp_use_secure_feature_key( 'system', 'securefkey' );
CALL sp_list_secure_feature_keys( );