AUTHLIB Procedure

Example 3: Binding a Library When Existing Data Sets Are Protected with the Same Passwords

Features:

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

Details

This example demonstrates how to specify the passwords for the Employees and EmpInfo data sets from the preceding example in the PROC AUTHLIB CREATE statement. None of the data sets are AES-encrypted.

Program

proc authlib lib=abcde;

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

Program Description

Library ABCDE also 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 ALTER= password ijkl before the library is secured by the statements. The third data set, Product, is not protected with any 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 the ALTER= password ijkl for the data sets in the PW= argument before the new password secretpw, separated by a slash (/).

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

Results:The library ABCDE is bound. All three data sets are bound with the same password secretpw.

Log Examples

Securing a Library with Data Sets That Are Protected with the Same Passwords

39   proc authlib lib=abcde;
40   create securedlibrary="ABCDEEmps"
41   securedfolder="Department XYZZY"
42   pw=XXXX/XXXXXXXX;
43   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: 9F746F86-2336-4E2F-A67E-BFB77DEC27F0
NOTE: Successfully added new secured table object "DEPTNAME.DATA" to the secured library object at path "/System/Secured
      Libraries/Department XYZZY/ABCDEEmps" for data set ABCDE.DEPTNAME.DATA.
NOTE: The passwords on ABCDE.DEPTNAME.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/ABCDEEmps" for data set ABCDE.EMPINFO.DATA.
NOTE: The passwords on ABCDE.EMPINFO.DATA were successfully modified.
NOTE: Successfully added new secured table object "EMPLOYEE.DATA" to the secured library object at path "/System/Secured
      Libraries/Department XYZZY/ABCDEEmps" for data set ABCDE.EMPLOYEE.DATA.
NOTE: The passwords on ABCDE.EMPLOYEE.DATA were successfully modified.
44   quit;