change admin password in apex3.0
SOLUTION FOUND - THANKS
I am trying to change the admin PW (actually PW lost) but having trouble. I am on apex3.0. After running the floowing code I return to apex_admin UI BUT I fail to get a login?
- thanks for any help,
Tom
I have run from a sqlplus window:
SQL> connect flows_030000@orcl_hidadwf20
Enter password: ************
Connected.
SQL> begin
2 wwv_flow_api.set_security_group_id(p_security_group_id=>10);
3
4 wwv_flow_fnd_user_api.create_fnd_user(
5 p_user_name => 'admin2',
6 p_email_address => 'myemail@mydomain.com',
7 p_web_password => 'admin2') ;
8
9 end;
10 /
PL/SQL procedure successfully completed.
SQL> commit ;
Commit complete.
SQL> connect system@orcl_hidadwf20
Enter password: *******
Connected.
SQL> alter user flows_030000 account lock ;
User altered.
Message was edited by:
marshall