Alters a previously-defined secure feature key by modifying the authorization key
and/or the feature list.
Syntax
sp_alter_secure_feature_key (
name,
auth_key,
features )
Parameters
- name – the VARCHAR (128) name for the secure feature key you want to alter. A key
with the given name must already exist.
- auth_key – the CHAR (128) authorization key for the secure feature key.
The authorization key must be either a non-empty string of at least six
characters, or NULL, indicating that the existing authorization key is not
to be changed.
- features – the LONG VARCHAR, comma-separated list of secure features
that the key can enable. The feature_list can be NULL, indicating that the
existing feature_list is not to be changed.
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 allows you to alter the authorization key or feature list of an
existing secure feature key.