Search found 3 matches

by Lora
Wed Feb 01, 2012 2:54 am
Forum: Application DBA & System Administration
Topic: Guest User Enable
Replies: 4
Views: 4626

Thanks for replay.

Profile Name:Signon Password Case
Site lebel
Value: Sensitive
by Lora
Wed Feb 01, 2012 1:21 am
Forum: Application DBA & System Administration
Topic: Guest User Enable
Replies: 4
Views: 4626

1. Yes you are correct. I should not try in Prod server.
2. R12.1.3
3. You are correct.
4. select fnd_web_sec.validate_login('GUEST','<Your Password Here>') from dual;

Output : N

5. I run autoconfig both in db and apps
by Lora
Tue Jan 31, 2012 1:34 pm
Forum: Application DBA & System Administration
Topic: Guest User Enable
Replies: 4
Views: 4626

Guest User Enable

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; d...