AUTHLIB Procedure

Example 10: Binding a Library When Existing Data Sets Are SAS Proprietary Encrypted

Features:
PROC AUTHLIB statement options:
CREATE statement options:
PW=
SECUREDLIBRARY=
SECUREDFOLDER=
TABLES statement options:
PW=
READ=

Details

The following example demonstrates how to bind and change passwords on SAS Proprietary encrypted data sets.

Program

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

Program Description

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 abcd. Both Employees and EmpInfo data sets are SAS Proprietary encrypted. 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.Set the library password to pqrstuvw.
    create securedlibrary="KLMNOEmps"
        securedfolder="Department XYZZY" 
        pw=pqrstuvw;
Because these data sets have different passwords, a TABLES statement must be specified for all data sets in order to change their passwords.
    tables employees / 
        pw=lmno; 
    tables empinfo / 
        read=abcd;  
    tables product; 
run;
quit;
Results:The library KLMNO is bound. All three data sets are bound and use the same PW= password pqrstuvw. Data sets Employees and EmpInfo are copied-in-place to encrypt with the password pqrstuvw. Data set Product is bound, but not encrypted.
 

Log Examples

TABLES Statement for the KLMNO Library Containing a SAS Proprietary Data Set
265  proc authlib lib=klmno;
266  create securedlibrary="KLMNOEmps"
267  securedfolder="Department XYZZY"
268  pw=XXXXXXXX;
269  tables employees /
270  pw=XXXX;
271  tables empinfo /
272  read=XXXX;
273  tables product;
274  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: E71881CD-8C54-4E21-A8B5-FD7D4FBDAA7D
NOTE: Copying data set KLMNO.EMPLOYEES in place to encrypt with the new secured library passwords or encryption options.
NOTE: Renaming the data set KLMNO.EMPLOYEES to KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: Copying the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__ to KLMNO.EMPLOYEES.
NOTE: Metadata-bound library permissions are used for KLMNO.EMPLOYEES.DATA.
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: There were 5 observations read from the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The data set KLMNO.EMPLOYEES has 5 observations and 6 variables.
NOTE: Deleting the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The passwords on KLMNO.EMPLOYEES.DATA were successfully modified.
NOTE: Copying data set KLMNO.EMPINFO in place to encrypt with the new secured library passwords or encryption options.
NOTE: Renaming the data set KLMNO.EMPINFO to KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: Copying the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__ to KLMNO.EMPINFO.
NOTE: Metadata-bound library permissions are used for KLMNO.EMPINFO.DATA.
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: There were 5 observations read from the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The data set KLMNO.EMPINFO has 5 observations and 6 variables.
NOTE: Deleting the data set KLMNO.__TEMP_ENCRYPT_FILE_NAME__.
NOTE: The passwords on KLMNO.EMPINFO.DATA were successfully modified.
NOTE: The passwords on KLMNO.PRODUCT.DATA do not require modification.
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.
275  quit;