Monday, March 30, 2009

Validating Guest user password

We generally come across a situation where we have to validate our Guest user password. I am mentioning some steps via backend to validate your Guest user password.
1. Check Value in DBC File
grep -i GUEST_USER_PWD $FND_SECURE/hostname_SID.dbc
GUEST_USER_PWD=GUEST/ORACLE

2. Check profile option value
sqlplus apps/passwd
SQL> select fnd_profile.value(’GUEST_USER_PWD’) from dual;
FND_PROFILE.VALUE(’GUEST_USER_PWD’)
——————————————————————————–
GUEST/ORACLE

Value for step 1 and 2 must be sync.

3. Guest user connectivity check
sqlplus apps/passwd
SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
——————————————————————————–-----
Y

Above is the value, then everything is perfect.
Happy Troubleshooting !!!

2 comments:

ram said...

Hi Sandeep,

I am working as DBA and I want to shift to apps dba demoin ..I also started learning things in apps..I have one doubt that, what is role of guest user in sign on process..
I have read in many blogs but not got clarity, a bit confusion taking place about applsyspub and guest user..
Can you please explain me in detail..I very happy to see your blog that given me good idea.. But i need what internally happens in sign on process ..i am trying to find out this answer since month by googling..please help me out..

Regard's,
Ramji M.

Sundeep Dubey said...

Ram
Look at what Vikram explained really well http://oracleappstechnology.blogspot.com/2007/08/apps-11i-login-flow.html