My Oracle Support Banner

How to create a custom report to retrieve the 'non-default schemas who own objects' against a database target (Doc ID 2020056.1)

Last updated on JANUARY 23, 2024

Applies to:

Enterprise Manager for Oracle Database - Version and later
Information in this document applies to any platform.


To demonstrate how to create a custom report to retrieve the non-default schemas (those which own objects) against a database target.

There is a list of default schemas given in:

Oracle® Database 2 Day + Security Guide
11g Release 2 (11.2)
Part Number E10575-05
Chapter 3 - Securing Oracle Database User Accounts/Predefined User Accounts Provided by Oracle Database

View the sections "Predifined Oracle Database Administrative User Accounts", "Predefined Non-Administrative User Accounts", and "Predefined Sample Schema User Accounts" to see the list of the default and sample provided schemas.

Also note that there may be additional default schemas provided by other tools.  For example, if the database hosts the EM repository, then additional schemas can be:


It may be necessary to amend the query given below according to personal requirements.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.