Skip to main content

Oracle_PublicPermissions Job

The Oracle_PublicPermissions Job provides a list of permissions assigned to Public profile in targeted Oracle database servers.

Analysis Tasks for the Oracle_PublicPermissions Job

Navigate to the Oracle > 3.Permissions > Oracle_PublicPermissions > 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:

  • Oracle Public Permissions – Analyzes permissions for the Public Oracle account. Creates the SA_Oracle_PublicPermission_Details table accessible under the job’s Results node.
  • Public Permissions Instance Summary – Summarizes public permissions by Instance. Creates the SA_Oracle_PublicPermission_InstanceSummary accessible under the job’s Results node.

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

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