Re: GUEST/ORACLE and APPLSYSPUB/PUB..
- From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 2 Aug 2007 15:10:52 +0300
Sreenivash,
Don't mix up to levels of authorization.
APPLSYSPUB/PUB - is DB username which is used by any utility to
retrieve APPS schema password for further logins.
GUEST/ORACLE - is EBS username with no or max limited privileges to
execute some authorization function.
I think both used during regular an End used authorization process.
First of all connection to DB using APPLSYSPUB/PUB then to EBS using
GUEST/ORACLE.
End of the day APPS user is used to establish final connection.
May be APPS connections came in to the action in between listed above.
Just my 0.02$
Jurijs
On 8/2/07, k srinivas <k.sridba@xxxxxxxxx> wrote:
> Hi DBAs,
>
> Can anybody plz point the exact difference between GUEST/ORACLE and
> APPLSYSPUB/PUB..
> and where does APPLSYSPUB/PUB comes into picture...
>
> I guess when User types his Username Password in login window and clicks
> submit button..Then
> Webserver checks that username and passwords need to authenticate against
> database FND_USER
> table..So GUEST/USER comes into picture...but Where does APPLSYSPUB/PUB
> comes into
> picture...
>
> Plz advice me.........
>
> Sreenivash.
--
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
Other related posts:
