Removing oracle/database credentials

[ConnorC]

Hello,

I have a workflow that I connect to an oracle with my own credentials.  Is there a way that I can have the workflow remove my credentials after running it? so the next person to open the workflow will need to enter their own credentials

[JagdeeshN]

Hi @ConnorC ,

Can you please clarify the following:-

1. Is the next person going to run this on their desktop or server?

2. Does each person have separate credential based access or is it the same connection(credentials) that some have access to.

If the next person is running this on their desktop, you can simply use the same alias but with different credentials. For eg. if you have create a connection named 'Oracle' on your machine with your credentials. The next person can create a connection with the same name but their credentials. In that way the workflow(alias) will dynamically pick up the credentials based on what is setup on that machine.

If you are accessing this on the server, you can achieve this by the means of data connections.

Hope this helps.

Best,

Jagdeesh