AUTHLIB Procedure

Example 7: Using the REMOVE Statement

Features:

PROC AUTHLIB statement options:: REMOVE statement options:; PW=

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 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 (/). None of the data sets are AES-encrypted.

Program

proc authlib lib=abcde;

    remove 
        pw=currntpw/; 
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.

    remove 
        pw=currntpw/; 
run;    
quit;

Results:The library ABCDE and all the data sets that are bound to it are no longer bound. All passwords are removed from the unbound data sets making them unprotected.

Log Examples

Unbinding a Metadata-Bound Library

195  proc authlib lib=abcde;
196  remove
197  pw=XXXXXXXX/;
198  run;

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.
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.
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: 9F746F86-2336-4E2F-A67E-BFB77DEC27F0
NOTE: Successfully deleted the recorded location of the secured library object for the physical library ABCDE.
199  quit;