AUTHLIB Procedure

Example 4: Securing a Library When Existing Data Sets Are Protected with Different Passwords

Features:

CREATE Statement and Options:: SECUREDLIBRARY=; SECUREDFOLDER=; PW=; ALTER=; READ=; WRITE=; TABLES

Details

Library KLMNO has three data sets: EMPLOYEES, EMPINFO, and PRODUCT. In this library, the EMPLOYEES data set is protected with the PW password lmno. The EMPINFO data set is protected with a Read password of abcd, a Write password of efgh, and an Alter password of ijkl. The PRODUCT data set is not protected. Because these data sets have different passwords, to change these passwords, you must use TABLES statements with the CREATE statement. When the TABLES statement is used, a TABLES statement must be specified for all tables. This example also uses three passwords to bind the library: READ=ABCDEFGH, WRITE=IJKLMNO, and ALTER=PQRSTUVW.

Program

proc authlib lib=klmno;
    create securedlibrary="KLMNOEmps"
       securedfolder="Department XYZZY" 
       read=abcdefgh write=ijklmno alter=pqrstuvw;
 
tables employees / pw=lmno; 
tables empinfo / read=abcd write=efgh alter=ijkl;  
tables product; 
 
run;
quit;

Log

Securing a Library with Existing Data Sets That Are Protected with Different Passwords

187  proc authlib lib=klmno;
188
189   create securedlibrary="KLMNOEmps"
190
191        securedfolder="Department XYZZY"
192        read=XXXXXXXX write=XXXXXXX alter=XXXXXXXX;
193
194  tables employees / pw=XXXX;
195  tables empinfo / read=XXXX write=XXXX alter=XXXX;
196  tables product;
197
198  run;

NOTE: Successfully created a secured library object for the physical library KLMNO and recorded its
      location as:
           SecuredFolder:      /System/Secured Libraries/Department XYZZY
           SecuredLibrary:     KLMNOEmps
           SecuredLibraryGUID: ABA4F5FB-F30A-4F20-9C0B-9F05E877B7BD
NOTE: Successfully added new secured table object "EMPLOYEES.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/KLMNOEmps" for data set KLMNO.EMPLOYEES.DATA.
NOTE: The passwords on KLMNO.EMPLOYEES.DATA were successfully modified.
NOTE: Successfully added new secured table object "EMPINFO.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/KLMNOEmps" for data set KLMNO.EMPINFO.DATA.
NOTE: The passwords on KLMNO.EMPINFO.DATA were successfully modified.
NOTE: Successfully added new secured table object "PRODUCT.DATA" to the secured library object at
      path "/System/Secured Libraries/Department XYZZY/KLMNOEmps" for data set KLMNO.PRODUCT.DATA.
NOTE: The passwords on KLMNO.PRODUCT.DATA were successfully modified.
199  quit;

NOTE: PROCEDURE AUTHLIB used (Total process time):
      real time           0.17 seconds
      cpu time            0.04 seconds