AUTHLIB Procedure

Example 9: Using the TABLES Statement

Features:

TABLE Statements and Options:: PW=; ALTER=; READ=; WRITE=

Details

Library KLMNO has three data sets in the TABLES statements: EMPLOYEES, EMPINFO, and PRODUCT.

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

TABLES Statement

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