oracle application user

Application Database Users:-

1.     Apps user

2.     Applsys

3.     Applsyspub

4.     Oracle

5.     Applmgr

6.     Gust user

Apps User is a Application Super User or Universal Schema. Apps User has complete access to EBS Data Module.  & APPS User has privilege to access all Application Objects.

•       All runtime Applications connect to Apps Schema,

•       Apps User is the owner of all Business Modules.

•       Apps is the owner of AOL (Application Object Library) at Database level.

•       All Tables Synonym of other Users by default will be granted to Apps User, so that the Apps User can be access the other Users Schema.

Applsys User is a common User created for all Technology Modules.

•       Applsys is a owner of All Technology Modules & (Application Data Dictionary). 

•       Applsys is the owner of Application at Database Level.

Sysadminis the System Administrator User to perform System Administrative tasks.

Applmgr User is the owner of Application Database Tire at O/S level.

Oracle Useris the owner of Oracle Database Tire at O/S level.

ApplsyspubUser checks the authentications. It will have all the login& logout details of the Users.

Note:- Apps is the default password for both Apps User and Applsys User.

If we change the Password of Apps User then it will automatically change the Password of Applsys User also.

Gust user:-

It is  application user with no responsibilities.

GUEST_USER_PWD=GUEST/ORACLE