sp_create_secure_feature_key System Procedure

Syntax

sp_create_secure_feature_key ( 
    name, 
    auth_key, 
    features )

Parameters

• name – the VARCHAR (128) name for the new secure feature key. This argument cannot be NULL or an empty string.
• auth_key – the CHAR (128) authorization key for the secure feature key. The authorization key must be a non-empty string of at least six characters.
• features – the LONG VARCHAR comma-separated list of secure features that the new key can enable. Specifying "-" before a feature means that the feature is not re-enabled when the secure feature key is set.

Privileges

You must have EXECUTE privilege on the system procedure. In addition, you must be the database server owner and have the manage_keys feature enabled on the connection.

Remarks

This procedure creates a new secure feature key that can be given to any user. The system secure feature key is created using the -sk database server option.