AUTHLIB Procedure

Example 17: Using the REMOVE Statement on a Metadata-Bound Library with Required AES Encryption

Features:
PROC AUTHLIB statement options:
REMOVE statement options:
PW=
ENCRYPT=

Details

This example demonstrates how to unbind a metadata-bound library. The code does the following:
  • deletes metadata that describes the library and its tables from the SAS Metadata Repository
  • removes security bindings from the physical library and data sets
  • removes the assigned password and encryption from the data sets, leaving them unprotected
The slash (/) after the password is optional and is used to remove or replace the password from the data sets. If a library is bound with READ=, WRITE=, and ALTER= passwords, as in Example 4, then you must specify all of the passwords, and they must each have a slash (/).

Program

proc authlib lib=abcde; 
    remove 
        pw=currntpw/ 
        encrypt=no;
run;
quit;
  

Program Description

Unbinding the metadata-bound library ABCDE.
proc authlib lib=abcde; 
Use the REMOVE statement to unbind the metadata-bound library. The slash (/) after the password is used to remove the password from the data sets. ENCRYPT=NO specifies that encryption is removed from all data sets.
    remove 
        pw=currntpw/ 
        encrypt=no;
run;
quit;
Results:The library ABCDE and all the data sets bound to it are no longer bound. All passwords and encryption are removed from the unbound data sets making them unprotected.
  
Using the REMOVE Statement on a Metadata-Bound Library with Required AES Encryption
642  proc authlib lib=abcde;
643  remove
644  pw=XXXXXX/
645  encrypt=no;
646  run;

NOTE: Copying data set ABCDE.DEPTNAME in place to remove encryption.
NOTE: Renaming the data set ABCDE.DEPTNAME to ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: Copying the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__ to ABCDE.DEPTNAME.
NOTE: There were 4 observations read from the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The data set ABCDE.DEPTNAME has 4 observations and 2 variables.
NOTE: Deleting the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
WARNING: Some or all the passwords on ABCDE.DEPTNAME.DATA were removed along with the secured library object location,
         leaving the data set unprotected.
NOTE: The secured table object location for ABCDE.DEPTNAME.DATA was successfully removed.
NOTE: Copying data set ABCDE.EMPINFO in place to remove encryption.
NOTE: Renaming the data set ABCDE.EMPINFO to ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: Copying the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__ to ABCDE.EMPINFO.
NOTE: There were 5 observations read from the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The data set ABCDE.EMPINFO has 5 observations and 6 variables.
NOTE: Deleting the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
WARNING: Some or all the passwords on ABCDE.EMPINFO.DATA were removed along with the secured library object location, leaving
         the data set unprotected.
NOTE: The secured table object location for ABCDE.EMPINFO.DATA was successfully removed.
NOTE: Copying data set ABCDE.EMPLOYEE in place to remove encryption.
NOTE: Renaming the data set ABCDE.EMPLOYEE to ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: Copying the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__ to ABCDE.EMPLOYEE.
NOTE: There were 5 observations read from the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The data set ABCDE.EMPLOYEE has 5 observations and 6 variables.
NOTE: Deleting the data set ABCDE.__TEMP_ENCRYPT_FILE_NAME__.
WARNING: Some or all the passwords on ABCDE.EMPLOYEE.DATA were removed along with the secured library object location,
         leaving the data set unprotected.
NOTE: The secured table object location for ABCDE.EMPLOYEE.DATA was successfully removed.
NOTE: Successfully deleted the secured library object that was located at:
           SecuredFolder:      /System/Secured Libraries/Department XYZZY
           SecuredLibrary:     ABCDEEmps
           SecuredLibraryGUID: 157F7ACD-5B71-4BC3-A490-DCED4BD275E8
NOTE: Successfully deleted the recorded location of the secured library object for the physical library ABCDE.
647  quit;