Control the database features available to users, by using the secure features database server option (-sf) to specify the features that users are prevented from accessing on the database server. The -sk database server option creates a system secure feature key, and the sp_create_secure_feature_key system procedure creates a customized secure feature key.
You must have the SERVER OPERATOR system privilege and have access to the manage_keys feature.
Secure feature settings apply to all databases running on a database server.
The secure features option (-sf) controls the availability of such features as:
The -sk option specifies a system secure feature key that manages access to secure features for a database server. To alter the list of secured features once the database server is running, use the sa_server_option system procedure. To alter a customized secure feature key once the database server is running, use the sp_alter_secure_feature_key system procedure.
There is now a system secure feature for the database server, as well as a customized secure feature that has been assigned to a specific user.