How to update password of libname statement of sas library

[jbond007]

Hi SAS Community,
Need your help on how to update the password on the "Display LIBNAME Statement" of sas library on SMC.
The password is encrypted yes but that one I know how to encrypt using pwencode.
The question is, where to update the password?

[gwootton]

The "Display LIBNAME Statement" function generates what it displays dynamically. So if you are logged in to SAS Management Console as User A, it would show the password accessible to User A. The password would be stored either under the user directly (User's Properties -> Accounts tab), or a group the user is a member of.

[jbond007]

Hi gwootton, 

Thank you, so it depends who logged in and run the display libname statement.

Oh I see, accounts tab is where will I update the password but from there I dont see any encryption options so I assume it will automatically encrypt it?

[SASKiwi]

I see your LIBNAME connects to SQL Server. Are you intending to have a static user/password for all data connections to this server because that looks like the way you have set this up? 

[gwootton · Accepted solution]

Correct, the displayed password is dependent on who is logged in to SAS Management Console. When you store a password in Metadata, the way it is encrypted on disk is set in the omaconfig.xml file using the STOREPASSWORDS option. By default I believe this is SAS005 or AES with a 64 bit salt and 10000 iterations.

Reference Information for omaconfig.xml
https://go.documentation.sas.com/doc/en/bicdc/9.4/bisag/n070fn7r6yuz53n19c7l80f3hr1g.htm