Please tell me how I can change the password from the Oracle database via KNIME.

Nuke_Attokurov · September 16, 2021, 5:44am

tobias.koetter · September 16, 2021, 6:35am

Hi,
just use the DB SQL Executor to execute the ALTER USER statement e.g.
ALTER USER my_user IDENTIFIED BY MyNewPassword123
Bye
Tobias

Nuke_Attokurov · September 19, 2021, 5:51am

Sorry there is another problem here.
When I just created a new ORACLE account for the first time and after opening it through the ORACLE CONNECTOR node, the system issues an error: ORA-28001

That is, it is impossible to put the DB SQL Executor node further and change the password. Because it does not open the ORACLE CONNECTOR node.
what to do?

mlauber71 · September 19, 2021, 8:34am

If you google this it means the password has expired.

ipazin · September 20, 2021, 10:43am

Hello @Nuke_Attokurov,

If you can’t or don’t know how to change your password on your own contact your database administrator. You can’t do it in KNIME.

Br,
Ivan

system · March 21, 2022, 10:43pm

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.