Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Oracle EBS default users in database

edited Aug 20, 2021 9:27AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered ✓

Hi team,


Our database is version 12.1.0.2.0 and EBS version is 12.1.3 on RHEL 7.

I received task from our auditor to get a list of non person usernames from our EBS database. As i know i can list database default users by this query:

select username,default_tablespace, account_status,created from dba_users

where oracle_maintained = 'Y';

Could you please tell me how to obtain information about usernames which are default from EBS database?

Because as far as i know EBS creates its own application schemas on database level for various purposes. I need to locate all schemas which are used by EBS itself and to present them to auditor.

Tagged:

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