ORA-28001 Handling

[Greg Stevenson]

How should one handle ORA-28001 expired password situations in DOA? I see that you handle it in PL/SQL Developer. When I try to execute "connect username alter authorization new_password" the connection logic seems to get in the way.
--Greg

 

[Marco Kalter]

The TOracleLogOn component will automatically handle password expiration. To explicitly change an expired password, use the TOracleSession.SetPassword procedure. The help-topic for this procedure describes things in detail.

------------------
Marco Kalter
Allround Automations