AUTHLIB Procedure

Example 2: Binding a Physical Library That Contains Password-Protected Data Sets

Features:

PROC AUTHLIB statement options:: CREATE statement options:; PW=; SECUREDLIBRARY=; SECUREDFOLDER=

Details

This example demonstrates what happens if you use a similar CREATE statement as Example 1 when the physical library contains two data sets that have the same READ=, WRITE=, and ALTER= passwords and one data set that does not have any passwords. None of the data sets are AES-encrypted.

Program

proc authlib lib=abcde;

    create securedfolder="Department XYZZY"    
        securedlibrary="ABCDEEmps"  
        pw=secretpw;   
run;
quit;

Program Description

Library ABCDE has Employees, EmpInfo, and Product data sets. However, in library ABCDE, the Employees and EmpInfo data sets are protected with a READ= password abcd, WRITE= password efgh, and an ALTER= password ijkl before the library is secured by the statements. The third data set, Product, is not protected with passwords.

proc authlib lib=abcde;

Using the CREATE statement, enter the name of the metadata folder and name the secured library object in the SAS Metadata Server. Specify metadata-bound library passwords with the PW= option.

    create securedfolder="Department XYZZY"    
        securedlibrary="ABCDEEmps"  
        pw=secretpw;   
run;
quit;

Results:The ABCDE library is bound and the unprotected Product data set is bound and the password was set. The protected data sets are not bound and their passwords did not change because their current passwords were not specified.

Log Examples

Password-Protected Data Sets

179  proc authlib lib=abcde;
180
181   create securedfolder="Department XYZZY"
182          securedlibrary="ABCDEEmps"
183          pw=XXXXXXXX;
184
185  run;

NOTE: Successfully created a secured library object for the physical library ABCDE and recorded its
      location as:
           SecuredFolder:      /System/Secured Libraries/Department XYZZY
           SecuredLibrary:     ABCDEEmps
           SecuredLibraryGUID: 4881263D-C346-41F7-AC49-BF9181AF13D2
ERROR: The ALTER password is the most restrictive on ABCDE.EMPINFO.DATA. You must supply its value in
       order to alter or add any passwords.
ERROR: The ALTER password is the most restrictive on ABCDE.EMPLOYEES.DATA. You must supply its value
       in order to alter or add any passwords.
NOTE: Successfully added new secured table object "PRODUCT.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/ABCDEEmps" for data set ABCDE.PRODUCT.DATA.
NOTE: The passwords on ABCDE.PRODUCT.DATA were successfully modified.
NOTE: Some statement actions not processed because of errors noted above.
186  quit;

NOTE: The SAS System stopped processing this step because of errors.