Re: GWYUID/GUEST_USER

srinivas,

   This is purely speculation, the internals of Oracle Applications are not 
publicy available.

   GWYUID is used during the logon process. From what I know, when you logon 
with a user and a password on forms, it initially connects with this user 
(APPLSYSPUB/PUB), then calls some packages using this user to obtain the APPS 
password. How this is done is not clear to me, but it involves validating the 
application user against FND_USER and then reading the APPS password from 
FND_ORACLE_USERID. When you logon through self-service, there is some session 
identifier passed to forms that is used to obtain the password too.

   The GUEST_USER_PWD is used internally by Oracle Applications whenever it 
needs to obtain a logon to the database. This is used by the "ad...ctl.sh" 
scripts, Jserv connection pool, and on some other places.

Regards,
Luis

--- On Wed, 12/10/08, k srinivas <k.sridba@xxxxxxxxx> wrote:

> From: k srinivas <k.sridba@xxxxxxxxx>
> Subject: GWYUID/GUEST_USER
> To: ora-apps-dba@xxxxxxxxxxxxx
> Date: Wednesday, December 10, 2008, 11:01 PM
> DBAS,
> 
> Whats the difference between GWYUID and GUEST_USER_PWD.One
> difference that I
> can make out is GWYUID is DB user whereas GUEST_ USer is
> EBS user.
> But I want to know whats the purpose of these users,where
> they came into
> picture,whts their significance in the context of
> connectivity.
> 
> Thanks in advance

Other related posts: