Automatically update DB passward which set in Environment

[EricLi]

We have a DB account for transaction report purpose, currently it is set in environment, but for security reason, the password is required to be changed in every 90 days. So that we have to manually make change in environment accordingly. 

Is there any way to update this password in environment without manual interact? Or any other ways suggest instead of environment?

[SayeedBinAbdullah]

Hi @EricLi 

Instead of using Environment variable you can use Blueprism Credentials Vault as it is more secure and the password can be updated using the Credentials VBO.

https://docs.blueprism.com/en-US/bundle/blue-prism-enterprise-6-7/page/helpCredentials.htm 

You can also click on "i" symbol to open documentation about Credentials VBO to get details steps about the mentioned action.

Best Regards,
Sayeed Bin Abdullah

[EricLi]

Hi, @SayeedBinAbdullah 

Thanks for your suggestion.

Credentials also need somewhere robot can access to get the latest password. I wanna a way that after password changed in DB by DBA, the new password will be automatically synchronized to blue prism in real-time instead of starting up a process to update. Not sure if it is possible.

[SayeedBinAbdullah]

Eric,

If possible can you attach screenshots to get better understanding of your requirement?

Best Regards,
Sayeed Bin Abdullah

[grbanares]

If the DBA has enough access rights to your Blue Prism DB, maybe they can crack a script to access the table that holds the credential.

I would suggest to get the credential stored in Credential Manager rather than Environment Vairable though. 🙂

[RoopkiranBevara]

Hi @EricLi ,

Always use credential manager to store the credentials that would be the best practice in RPA. Kindly avoid using EV's to store the Credentials. & Please check the permissions to access the BP to avoid this type of issues.