sp_create_secure_feature_key System Procedure

Syntax

sp_create_secure_feature_key ( 
    name, 
    auth_key, 
    features ) 

Arguments

• 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.

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.

Privileges

To use this procedure, you must be the database server owner and have the manage_keys feature enabled on the connection.