Brad Peek wrote:
I just noticed that (at least for me) SQL History is not including "alter user xxxx account unlock;" when it executed from Worksheet as a single statement (not part of a script).
SQL Dev 18.104.22.168.78 (possibly other versions as well).
The statement does complete successfully, but does not show up in SQL History.
Anyone else notice the same thing?
another possible solution:
You can find the article here: http://www.thatjeffsmith.com/archive/2011/12/sql-developer-quick-tip-accessing-sql-history-with-the-keyboard/
Not certain, but possibly ALTER USER statements are not recorded in SQL History to avoid storing a clear text password in the case of a statement containing an IDENTIFIED BY clause.