Run the file created in Step 4 to encrypt the file. Proc pwencode in=' password' out=pwfile method=sas002 Log in to the PSUB server as RXC_SAS_VIEW owner and set the environment:Ĭreate a temporary SAS file named pwd.sas to contain the password for the sas_proxy_user account:įilename pwfile 'sas_proxy_password_encoded_file' Run the script ocl_grant_revoke_sas_proxy_user.sql in the install directory to grant or revoke user connections through proxy account sas_proxy_user Grant proxy connection for each database user account who needs to submit SAS Data Extract jobs:Īlter user grant connection through sas_proxy_user Log in to the database as system user and create the sas_proxy_user database account:Ĭreate user sas_proxy_user identified by Manually set SAS_ENCRYPTION as the SAS_CONNECTION long value in the OCL_STATE local reference codelist.
