Returns information about the contents of a directory.
sp_list_secure_feature_keys ( )
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.
| Column Name | Data Type | Description |
|---|---|---|
| name | VARCHAR(128) | The name of the secure feature key. |
| features | LONG VARCHAR | The secure features enabled by the secure feature key. |
This procedures returns the names of existing secure feature keys, as well as the set of secure features that can be enabled by each key.
If the user has the manage_features and manage_keys secure features enabled, then the procedure returns a list of all secure feature keys.
If the user only has the manage_keys secure 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.