|
Returns a list of defined secured feature keys.
sp_list_secure_feature_keys( )| Column name | Data type | Description |
|---|---|---|
| name | VARCHAR(128) | The name of the secured feature key. |
| features | LONG VARCHAR | The secured features enabled by the secured feature key. |
You must have the MANAGE_KEYS feature enabled on the connection to run this procedure.
This procedures returns the names of existing secured feature keys, as well as the set of features that can be enabled by each key.
If the user has the MANAGE_FEATURES and MANAGE_KEYS features enabled, then the procedure returns a list of all secured feature keys.
If the user only has the MANAGE_KEYS feature enabled, then the procedure returns keys that have the same features or a subset of the same features that the current user has enabled.
You must have EXECUTE privilege on the system procedure, as well as the SERVER OPERATOR system privilege.
None
In order for the following example to work, the server must be started with the option: -sk securefkey.
This example enables the SYSTEM secured feature key which includes the MANAGE_FEATURES and MANAGE_KEYS features, and then uses sp_list_secure_feature_keys to obtain a list of all the current secured feature keys:
CALL sp_use_secure_feature_key( 'system', 'securefkey' ); CALL sp_list_secure_feature_keys( );