String

NULL

Can be set as a temporary option only, for the duration of the current connection.

You can specify features that cannot be used by databases running on a server by including the -sf database server option when you start the database server. The -sk server option lets you specify a key that can be used to re-enable all secured (disabled) features for a connection and gives that connection permission to change the features that are secured for all databases running on the database server. When you set the value of the secure_feature_key temporary option to the value specified by -sk when the database server was started, then all features are re-enabled for that database connection, and on that connection you can use the sa_server_option system procedure to control access to database features.

If the secure_feature_key option is set to any value other than the one specified by the -sk database server option, no error is given, and the features specified by -sf database server option remain disabled for the connection.

• sp_use_secure_feature_key system procedure
• -sk database server option
• -sf database server option
• sa_server_option system procedure
• Creating secure feature keys

The following command starts a database server named secure_server with access to the request log and all remote data access features disabled. The key specified by the -sk option can be used later to enable these features for a specific database connection.

dbsrv16 -n secure_server -sf request_log,remote -sk j978kls12 testdb.db

Setting the secure_feature_key option to the value specified by -sk for a database running on the secure_server database server enables access to the request log and remote data access features for that connection:

SET TEMPORARY OPTION secure_feature_key = 'j978kls12';