Creates a new secure feature key.
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.