topic Re: Automatically update DB passward which set in Environment in Product Forum

Automatically update DB passward which set in Environment

EricLi — Mon, 18 Aug 2025 03:12:55 GMT

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?

Re: Automatically update DB passward which set in Environment

SayeedBinAbdullah — Mon, 18 Aug 2025 05:52:11 GMT

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

Re: Automatically update DB passward which set in Environment

EricLi — Mon, 18 Aug 2025 09:01:54 GMT

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.

Re: Automatically update DB passward which set in Environment

SayeedBinAbdullah — Mon, 18 Aug 2025 10:30:57 GMT

Eric,

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

Best Regards,
Sayeed Bin Abdullah

Re: Automatically update DB passward which set in Environment

grbanares — Fri, 29 Aug 2025 13:11:19 GMT

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. 🙂

Re: Automatically update DB passward which set in Environment

RoopkiranBevara — Mon, 08 Sep 2025 05:28:24 GMT

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.