How to Reset Admin Password
474344Jun 23 2008 — edited Jun 23 2008The admin account password keeps returning an "Invalid Password" error. I've read through some the threads and went through the recommended steps to reset it using the following script and it still is not unlocking the admin account:
alter user FLOWS_010600 account unlock;
connect FLOWS_010600/apex;
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'myemail@blah.blah',
p_web_password => 'admin2') ;
end;
/
alter user FLOWS_010600 account lock;
alter user FLOWS_020200 account unlock;
connect FLOWS_020200/apex;
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin2',
p_email_address => 'myemail@blah.blah',
p_web_password => 'admin2') ;
end;
/
alter user FLOWS_020200 account lock;
alter user FLOWS_030000 account unlock;
connect FLOWS_030000/apex;
begin
wwv_flow_api.set_security_group_id(p_security_group_id=>10);
wwv_flow_fnd_user_api.create_fnd_user(
p_user_name => 'admin',
p_email_address => 'myemail@blah.blah',
p_web_password => 'htmldb') ;
end;
/
Another suggestion was to change the security group in this script from 10 to 20, so I tried that also with no luck. The URL I'm trying to login through is: pls/apex/f?p=4550:10. Any suggestions would be appreciated - I'm stuck!