Skip to main content

Oracle_Users Job

The Oracle_Users Job is designed to provide insight into all attributes associated with users in all databases in targeted Oracle database servers.

Analysis Tasks for the Oracle_Users Job

Navigate to the Oracle > 1.Users and Roles > Oracle_Users > Configure node and select Analysis to view the analysis tasks.

warning

Do not modify or deselect the selected analysis tasks. The analysis tasks are preconfigured for this job.

Analysis Selection

The default analysis tasks are:

  • Determine user details – Creates the SA_Oracle_Users_Details table accessible under the job’s Results node
  • Summarize by Instance – Creates the SA_Oracle_Users_Summary table accessible under the job’s Results node

In addition to the tables and views created by the analysis tasks, the Oracle_Users Job produces the following pre-configured report.

ReportDescriptionDefault TagsReport Elements
Oracle UsersThis report shows details on users in the audited Oracle environmentNoneThis report is comprised of three elements:
  • Bar Chart – Displays users by instance
  • Table – Provides details on oracle user instance summary
  • Table – Provides information on oracle user details