Technology Stack - EBS (MOSC)

MOSC Banner

What are the default and least privileges for Oracle EBS Apps User

edited Aug 26, 2014 11:23AM in Technology Stack - EBS (MOSC)

Hi all,

Can any one provide the list of the default roles and privileges granted to APPs user from a fresh installation ?

Please advise.

Thank you

C.

Hi,

Here are the role and privileges for a 12.1.3 environment:

select * from DBA_ROLE_PRIVS

where GRANTEE    ='APPS'

/

GRANTEE                   GRANTED_ROLE              ADM DEF

------------------------------ ------------------------------ --- ---

APPS                      RESOURCE                  NO  YES
APPS                      CONNECT                   NO  YES
APPS                      HR_REPORTING_USER         YES YES
APPS                      CTXAPP                    NO  YES
APPS                      OWS_STANDARD_ROLE         NO  YES
APPS                      WEBDB_DEVELOPER           NO  YES
APPS                      APPS_CONNECT              NO  YES
APPS                      HR_SECURE_USER            YES YES
APPS                      XDBADMIN                  NO  YES
APPS                      JAVASYSPRIV              

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center