Removes the physical security information and metadata objects that protect a metadata-bound library so that it is no longer a metadata-bound library.
Requirement: | The AUTHLIB REMOVE statement requires a connection to the target metadata server. For more requirements, see Requirements for Using the AUTHLIB Statements. |
Note: | If any data set uses SAS Proprietary Encryption, then you cannot remove passwords unless you also specify ENCRYPT=NO to remove encryption. |
Tips: | Each password and encryption key option must be coded on a separate line to ensure that they are properly blotted in the log. |
If you do not want the non-secured data sets altered, then move all non-secured data sets from the physical library before performing a REMOVE statement. | |
Before you use the REMOVE statement, consider running the REPORT statement. The output from the REPORT statement identifies any physical tables that do not have corresponding secured table objects in metadata. In the unusual circumstance that such physical tables exist, their security location information is unaffected by the REMOVE statement unless you specify AUTHADMIN=YES in the LIBNAME statement. You should use the AUTHADMIN=YES option in the LIBNAME statement in this circumstance. | |
Examples: | Using the REMOVE Statement Using the REMOVE Statement on a Metadata-Bound Library with Required AES Encryption |
specifies a single password for a metadata-bound library.
specifies one of a maximum of three password values for a metadata-bound library.
specifies one of a maximum of three password values for a metadata-bound library.
specifies one of a maximum of three password values for a metadata-bound library.
specifies the encryption type.
specifies the SAS Proprietary algorithm.
specifies no encryption.
specifies Advanced Encryption Standard (AES) encryption and is required if specifying that data sets be encrypted with a new key value.
See | Encrypted Data Set Considerations |
specifies a key value for AES encryption.
Tip | The ENCRYPTKEY= value is a passphrase that can be up to 64 characters long from which the actual AES encryption key is later derived, but it is referred to as the encryption key in most SAS documentation. |
See | ENCRYPTKEY= Data Set Option in SAS Data Set Options: Reference |
name of the physical library that is metadata-bound.
If the LIBRARY= option is not specified, then the physical library from the PROC AUTHLIB statement is used.
Alias | LIB=, DDNAME=, DD= |
Restriction | The physical library specified cannot be a concatenated library, temporary library, or accessed through a SAS/SHARE server and must be processed by an engine that supports metadata-bound libraries. |
specifies whether the REMOVE statement action is applied at the library level or just to the tables. If TABLESONLY=NO, then the action is applied to the library and data sets. If TABLESONLY=YES, then the action is applied only to the individual data sets listed.
Default | NO |
Tip | If you specify TABLESONLY=YES and a new password or encryption options, then the new password or encryption options are ignored. The current password is still required if the library is metadata-bound. |