Oracle - User password change using TK Expect template

Create a new template, in the menu Executions > Settings > Templates:

Name: Oracle - User password change using TK Expect

Executor: TK Expect

Execution Type: Password change

Content:

use sqlplus
exec “ALTER USER [#USERNAME#] IDENTIFIED BY \”[#NEW_PASSWORD#]\“;”
expect “User altered.”

IMPORTANT
Oracle doesn’t support the character “@” in the user password creation/change. Create a new “Policy Credentials” using a “Password Strength” that will not use this character.

2 Likes