AUTHLIB Procedure

Example 5: Changing Passwords on Data Sets

Features:

MODIFY Statement and Options:: LIBRARY=; PW=; TABLESONLY=

Details

This example shows a different approach for modifying the passwords of existing data sets to match the metadata-bound library passwords. It uses the MODIFY statement. Here, the MODIFY statement is used to modify the data set passwords of the EMPLOYEES and EMPINFO data sets from Example 2 to match the metadata-bound library password. The MODIFY statement can also be used to modify the data set passwords of data sets that are copied into a metadata-bound library by operating system commands after the library has been bound. The existing data sets’ Alter password is specified in the PW= argument before the metadata-bound password, separated by a slash (/). The TABLESONLY statement specifies to modify table passwords only.

Program

proc authlib lib=abcde; 
   modify tablesonly=yes pw=ijkl/secretpw; 
run;    
quit;

Log

Changing Data Set Passwords

200  proc authlib lib=abcde;
201   modify tablesonly=yes pw=XXXX/XXXXXXXX;
202    run;

NOTE: Successfully added new secured table object "EMPINFO.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/ABCDEEmps" for data set ABCDE.EMPINFO.DATA.
NOTE: The passwords on ABCDE.EMPINFO.DATA were successfully modified.
NOTE: Successfully added new secured table object "EMPLOYEES.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/ABCDEEmps" for data set ABCDE.EMPLOYEES.DATA.
NOTE: The passwords on ABCDE.EMPLOYEES.DATA were successfully modified.
NOTE: The passwords on ABCDE.PRODUCT.DATA do not require modification.
203  quit;

NOTE: PROCEDURE AUTHLIB used (Total process time):
      real time           0.07 seconds
      cpu time            0.01 seconds