What are the default and least privileges for Oracle EBS Apps User
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 |