Guest User Enable
Posted: Tue Jan 31, 2012 1:34 pm
For Enable Guest user I did following thing .........
1. Reset GUEST password:
SQL> exec fnd_vault.del('FND');
SQL> commit;
SQL> select FND_WEB_SEC.CHANGE_GUEST_PASSWORD ('ORACLE','Lora123') from dual;
SQL> commit;
2. Test if Profile Updated or not?
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD','GUEST/Lora123','SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
end;
3. Bounce Instance .
But I can not log on my Instance . I am in Prod Server Please help me ASAP. when I try to log on it gives me Http 500 server error. There are around 4000 user waiting for me. So please ............
Can i revert fnd_vault.del('FND') command.I mean if I go to my previous status that also ok.
1. Reset GUEST password:
SQL> exec fnd_vault.del('FND');
SQL> commit;
SQL> select FND_WEB_SEC.CHANGE_GUEST_PASSWORD ('ORACLE','Lora123') from dual;
SQL> commit;
2. Test if Profile Updated or not?
DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('GUEST_USER_PWD','GUEST/Lora123','SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
end;
3. Bounce Instance .
But I can not log on my Instance . I am in Prod Server Please help me ASAP. when I try to log on it gives me Http 500 server error. There are around 4000 user waiting for me. So please ............
Can i revert fnd_vault.del('FND') command.I mean if I go to my previous status that also ok.