Im working on an application which is used to change the Teradata passwords. If a person want to change the password in the Teradata DB, He should provide the Old password as well as new password to the application. With the help of the userID and the old password, it will connect to the Teradata DB and updates the password. So actually, I dont want to use the userID/ password in the Datasource setup to connect to teradata.
In short, the connection is to be made only with the help of the username/password provided during running the application, not with the datasource username/password.
Any idea???