Skip to main content

Oracle_ServerPermissions Job

The Oracle_ServerPermissions Job analyzes permissions granted at the database level and reports on effective database level permissions across all audited Oracle database servers.

Analysis Tasks for the Oracle_ServerPermissions Job​

Navigate to the Oracle > 3.Permissions > Oracle_ServerPermissions > Configure node and select Analysis to view the analysis tasks.

CAUTION: 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 Server Permissions – Highlights Oracle permissions on the Server. Creates the SA_Oracle_ServerPermission_Details table accessible under the job’s Results node.
  • Server Permissions Instance Summary – Summarizes server permissions by Instance. Creates the SA_Oracle_ServerPermission_InstanceSummary table accessible under the job’s Results node.

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

ReportDescriptionDefault TagsReport Elements
Server PermissionsThis report highlights server permissions and summarizes them by instanceNoneThis report is comprised of three elements: - Bar Chart – Displays top instances by server permissions - Table – Provides details on instances by server permission count - Table – Provides details on server permissions