AUTHLIB Procedure
- Syntax
- Overview
- Concepts
- Using
- Results
- Examples Binding a Physical Library That Contains Unprotected Data SetsBinding a Physical Library That Contains Password-Protected Data SetsBinding a Library When Existing Data Sets Are Protected with the Same PasswordsBinding a Library When Existing Data Sets Are Protected with Different PasswordsChanging Passwords on Data SetsChanging Metadata-Bound Library PasswordsUsing the REMOVE StatementUsing the REPORT StatementUsing the TABLES StatementBinding a Library When Existing Data Sets Are SAS Proprietary EncryptedBinding a Library When Existing Data Sets Are AES-EncryptedBinding a Library with an Optional Recorded Encryption Key When Existing AES-Encrypted Data Sets Have Different Encryption Keys Binding a Library with Required AES Encryption When Existing Data Sets Are Encrypted with the Same Encryption KeyChanging the Encryption Key on a Metadata-Bound Library That Requires AES EncryptionBinding a Library with Existing Data Sets That Are AES-Encrypted with Different Encryption KeysChanging a Metadata-Bound Library to Require AES Encryption When Existing Data Sets Are Encrypted with Different Encryption KeysUsing the REMOVE Statement on a Metadata-Bound Library with Required AES EncryptionResetting Credentials on Imported SecuredLibrary Objects
Example 5: Changing Passwords on Data Sets
| Features: |
|
Details
This example shows a different approach for modifying the passwords of existing data
sets to match the metadata-bound library passwords. It uses the MODIFY statement.
Here, the MODIFY statement is used to modify the data set passwords of the Employees
and EmpInfo data sets from Example 2 to match the metadata-bound library
password. Neither of these data sets are AES-encrypted.
The MODIFY statement can also be used to modify the data set passwords of data sets
that are copied into a metadata-bound library by operating system commands after the
library has been bound.
Program
proc authlib lib=abcde;
modify tablesonly=yes
pw=secretpw;
tables _all_ /
pw=ijkl/secretpw;
run;
quit;
Program Description
Library ABCDE has Employees, EmpInfo, and Product data
sets. The library is bound with metadata-bound
library password secretpw.
However, in library ABCDE, the Employees and EmpInfo data sets are
not bound to the library and are protected with an ALTER= password
ijkl.
The third data set, Product, is already bound.proc authlib lib=abcde;
The MODIFY statement is used to modify the data set passwords
of the Employees and EmpInfo data sets to match the metadata-bound
library password. The TABLESONLY= statement
specifies to modify table passwords only.
modify tablesonly=yes
pw=secretpw;A TABLES statement must be specified.The existing data sets’ ALTER password is
specified in the PW= argument before the metadata-bound password,
separated by a slash (/) in the TABLES statement.
tables _all_ /
pw=ijkl/secretpw;
run;
quit;
Results:All three data sets
are now bound with the secretpw password.
Log Examples
Changing Data Set Passwords
76 proc authlib lib=abcde; 77 modify tablesonly=yes 78 pw=XXXXXXXX; 79 tables _all_ / 80 pw=XXXX/XXXXXXXX; 81 run; NOTE: The passwords on ABCDE.DEPTNAME.DATA do not require modification. NOTE: The passwords on ABCDE.EMPINFO.DATA do not require modification. NOTE: The passwords on ABCDE.EMPLOYEE.DATA do not require modification. 82 quit;
Copyright © SAS Institute Inc. All rights reserved.