AUTHLIB Procedure

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

Features:

PROC AUTHLIB statement options:: CREATE statement options:; ALTER=; READ=; SECUREDLIBRARY=; SECUREDFOLDER=; WRITE=; TABLE statement options:; ALTER=; PW=; READ=; WRITE=

Details

This example demonstrates how to bind the library KLMNO, which contains three data sets with different passwords. None of the data sets are AES-encrypted. It also demonstrates creating a longer metadata-bound library password by specifying the READ=, WRITE=, and ALTER= password options.

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;

Program Description

Library KLMNO has Employees, EmpInfo, and Product data sets.The Employees data set is protected with the PW= password lmno. The EmpInfo data set is protected with a READ= password abcd, a WRITE= password efgh, and an ALTER= password ijkl. The Product data set is not protected.

proc authlib lib=klmno;

Using the CREATE statement, enter the name of the metadata folder and name the secured library object in the SAS Metadata Server.Specify the values for READ= password abcdefgh, WRITE= password ijklmno, and ALTER= password pqrstuvw to create a longer metadata-bound library password.

    create securedlibrary="KLMNOEmps"
        securedfolder="Department XYZZY" 
        read=abcdefgh 
        write=ijklmno 
        alter=pqrstuvw;

Use the TABLES statement to specify the current password for each data set.When using TABLES statements, a TABLES statement must be specified for all data sets.

    tables employees / 
        pw=lmno; 
    tables empinfo / 
        read=abcd 
        write=efgh  
        alter=ijkl;  
    tables product; 
run;
quit;

Results:The library KLMNO is bound, and all three data sets are bound with the same passwords. The passwords are READ= password abcdefgh, WRITE= password ijklmno, and ALTER= password pqrstuvw.

Log Examples

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

177  libname klmno "c:\lib2";
NOTE: Libref KLMNO was successfully assigned as follows:
      Engine:        V9
      Physical Name: c:\lib2
178
179  proc authlib lib=klmno;
180  create securedlibrary="KLMNOEmps"
181  securedfolder="Department XYZZY"
182  read=XXXXXXXX
183  write=XXXXXXX
184  alter=XXXXXXXX;
185  tables employees /
186  pw=XXXX;
187  tables empinfo /
188  read=XXXX
189  write=XXXX
190  alter=XXXX;
191  tables product;
192  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: BC74E81F-E86B-402E-8C16-F9A94A078F81
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.
193  quit;