AUTHLIB Procedure

Example 6: Changing Metadata-Bound Library Passwords

Features:
PROC AUTHLIB statement options:
MODIFY statement options:
PW=
SECUREDLIBRARY=
SECUREDFOLDER=

Details

This example demonstrates how to use the MODIFY statement to change the library passwords if you believe that the metadata-bound library passwords have been compromised. The following code changes the library passwords and the data set passwords of all data sets in the library that use the specified passwords or do not have a password. In this example, no data sets are AES-encrypted. See later examples if your library has AES-encrypted data.

Program

proc authlib lib=abcde; 
    modify securedlibrary="ABCDEEmps" 
        securedfolder="Department XYZZY" 
        pw=secretpw/new-password;  
run; 
quit;

Program Description

Library ABCDE requires a password change.
proc authlib lib=abcde;
Use the MODIFY statement to change the library passwords and the data set passwords. Note that the name of the secured library object and the name of the metadata folder are optional, but can be specified to ensure that the library is bound to that secured library object before making the change. This is used when the SAS Management Console submits the code from the Modify action to ensure that the correct operation system library path was specified.
    modify securedlibrary="ABCDEEmps" 
        securedfolder="Department XYZZY" 
        pw=secretpw/new-password;  
run; 
quit;
Results:The library ABCDE remains bound and the library password is modified to the new-password. All three data sets remain bound, and their passwords are modified with new-password. An error message would be displayed in the SAS log for any data set that had a password other than secretpw.

Log Examples

Changing Metadata-bound Library Passwords
217  proc authlib lib=abcde;
218    modify securedlibrary="ABCDEEmps"
219        securedfolder="Department XYZZY"
220        pw=XXXXXXXX/XXXXXXXX;
221
222  run;

NOTE: The passwords for the secured library object with path "/System/Secured Libraries/Department
      XYZZY/ABCDEEmps" were successfully modified."
NOTE: The passwords on ABCDE.EMPINFO.DATA were successfully modified.
NOTE: The passwords on ABCDE.EMPLOYEES.DATA were successfully modified.
NOTE: The passwords on ABCDE.PRODUCT.DATA were successfully modified.
223  quit;
Copyright © SAS Institute Inc. All rights reserved.