Policy-Details für Datenbankmanagement

Die Themen in diesem Abschnitt enthalten Details zum Schreiben von Oracle Cloud Infrastructure Identity and Access Management-(IAM-)Policys, um den Zugriff auf den Database Management-Service zu kontrollieren.

Im Folgenden finden Sie detaillierte Informationen und Beispiele für Policys, die für die Arbeit mit Database Management erforderlich sind:

Ressourcenarten

Ressourcentypen für Oracle Database, externes Datenbanksystem und Exadata-Infrastruktur

Aggregierte Ressourcenarten

dbmgmt-family

dbmgmt-dblm-family

Hinweis

Der aggregierte Ressourcentyp dbmgmt-family umfasst alle einzelnen Database Management-Ressourcentypen und den aggregierten Ressourcentyp dbmgmt-dblm-family, der wiederum die folgenden individuellen Ressourcentypen enthält:
  • dbmgmt-dblm-vulnerability
  • dbmgmt-dblm-workrequest
  • dbmgmt-dblm-patch-mgmt
  • dbmgmt-dblm-patch-operations

Individuelle Ressourcentypen

  • dbmgmt-jobs
  • dbmgmt-managed-database-groups
  • dbmgmt-managed-databases
  • dbmgmt-private-endpoints
  • dbmgmt-work-requests
  • dbmgmt-external-dbsystem-discoveries
  • dbmgmt-external-dbsystems
  • dbmgmt-external-exadata
  • dbmgmt-named-credentials
  • dbmgmt-dblm-vulnerability
  • dbmgmt-dblm-workrequest
  • dbmgmt-dblm-patch-mgmt
  • dbmgmt-dblm-patch-operations
  • dbmgmt-sqlwatch-fleet
  • dbmgmt-sqlwatch-spa

Ressourcentypen für HeatWave und externe MySQL-DB-Systeme

Aggregierter Ressourcentyp

dbmgmt-mysql-family

Einzelner Ressourcentyp

  • dbmgmt-managed-mysql-databases
  • dbmgmt-external-mysql-databases
  • dbmgmt-external-mysql-database-connectors

Kommentare

Eine Policy, die <verb> dbmgmt-family verwendet, entspricht dem Schreiben einer Policy mit einer separaten <verb> <individual resource-type>-Anweisung für die einzelnen individuellen Ressourcentypen in der Familie.

Details zu den API-Vorgängen, die von jedem Verb für jeden Ressourcentyp abgedeckt werden, finden Sie in den Tabellen unter Details für Kombinationen aus Verb + Ressourcentyp.

Unterstützte Variablen

Nur allgemeine Variablen werden unterstützt. Weitere Informationen finden Sie unter Allgemeine Variablen für alle Anforderungen.

Details zu Kombinationen aus Verb und Ressourcentyp

In den folgenden Tabellen sind die Berechtigungen und API-Vorgänge aufgeführt, die von den einzelnen Verben abgedeckt werden. Die Berechtigungen nehmen in dieser Reihenfolge zu: inspect > read > use > manage. Ein Pluszeichen (+) in einer Tabellenzelle gibt den inkrementellen Zugriff im Vergleich zur Zelle direkt darüber an, während "Keine zusätzlichen" keinen inkrementellen Zugriff angibt.

dbmgmt-jobs

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_JOB_INSPECT

ListJobs

keine

gelesen

UNTERSUCHEN +

DBMGMT_JOB_READ

GetJob

ListJobRuns

GetJobRun

ListJobExecutions

GetJobExecution

SummarizeJobExecutionsStatuses

keine

verwenden

LESEN +

keine zusätzlichen

keine

keiner

verwalten

BENUTZEN +

DBMGMT_JOB_CREATE

DBMGMT_JOB_DELETE

DBMGMT_JOB_MOVE

DBMGMT_JOB_UPDATE

ChangeJobCompartment

DeleteJob

UpdateJob

CreateJob (gibt auch use dbmgmt-managed-database-groups oder use dbmgmt-managed-databases an)

ImplementOptimizerStatisticsAdvisorRecommendations (benötigt auch use dbmgmt-managed-databases)

dbmgmt-managed-database-groups

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_MANAGED_DB_GROUP_INSPECT

ListManagedDatabaseGroups

keine

gelesen

PRÜFEN +

DBMGMT_MANAGED_DB_GROUP_READ

GetManagedDatabaseGroup

GetDatabaseFleetBackupMetrics (erfordert auch read dbmgmt-managed-databases)

GetDatabaseFleetDataguardMetrics (erfordert auch read dbmgmt-managed-databases)

GetDatabaseFleetHaOverviewMetrics (erfordert auch read dbmgmt-managed-databases)

GetDatabaseFleetHealthMetrics (auch read dbmgmt-managed-databases erforderlich)

verwenden

LESEN +

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

DBMGMT_MANAGED_DB_GROUP_UPDATE

UpdateManagedDatabaseGroup

CreateJob (auch manage dbmgmt-jobs erforderlich)

verwalten

USE +

DBMGMT_MANAGED_DB_GROUP_ADD_DATABASE

DBMGMT_MANAGED_DB_GROUP_CREATE

DBMGMT_MANAGED_DB_GROUP_DELETE

DBMGMT_MANAGED_DB_GROUP_MOVE

DBMGMT_MANAGED_DB_GROUP_REMOVE_DATABASE

ChangeManagedDatabaseGroupCompartment

CreateManagedDatabaseGroup

DeleteManagedDatabaseGroup

AddManagedDatabaseToManagedDatabaseGroup (benötigt auch use dbmgmt-managed-databases)

RemoveManagedDatabaseFromManagedDatabaseGroup (benötigt auch use dbmgmt-managed-databases)

dbmgmt-managed-databases

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_MANAGED_DB_INSPECT

ListManagedDatabases

keine

gelesen

PRÜFEN +

DBMGMT_MANAGED_DB_READ

GetAwrDbReport

GetAwrDbSqlReport

GetClusterCacheMetric

GetDatabaseFleetBackupMetrics

GetDatabaseFleetDataguardMetrics

GetDatabaseFleetHaOverviewMetrics

GetDatabaseFleetHealthMetrics

GetDatabaseHaBackupDetails

GetDatabaseHomeMetrics

GetDataguardPerformanceMetrics

GetManagedDatabase

GetPdbMetrics

GetPeerDatabaseMetrics

GetPreferredCredential

GetTablespace

ListAwrDbs

ListAwrDbSnapshots

ListPreferredCredentials

ListTablespaces

SummarizeAwrDbCpuUsages

SummarizeAwrDbMetrics

SummarizeAwrDbParameterChanges

SummarizeAwrDbParameters

SummarizeAwrDbSnapshotRanges

SummarizeAwrDbSysstats

SummarizeAwrDbTopWaitEvents

SummarizeAwrDbWaitEventBuckets

SummarizeAwrDbWaitEvents

TestPreferredCredential

keine

verwenden

LESEN +

DBMGMT_MANAGED_DB_CONTENT_READ

DBMGMT_MANAGED_DB_CONTENT_WRITE

DBMGMT_MANAGED_DB_UPDATE

AddmTasks

ChangeDatabaseParameters

ChangeDatafiles

ChangePlanRetention

ChangeSpaceBudget

ChangeSqlPlanBaselinesAttributes

CloneSqlTuningTask

CoalesceTablespace

ConfigureAutomaticCaptureFilters

ConfigureAutomaticSpmEvolveAdvisorTask

CreateSqlTuningSet

CreateTablespace

DeletePreferredCredential

DeleteTablespace

DisableAutomaticInitialPlanCapture

DisableAutomaticSpmEvolveAdvisorTask

DisableHighFrequencyAutomaticSpmEvolveAdvisorTask

DisableSqlPlanBaselinesUsage

DropSqlPlanBaselines

DropSqlsInSqlTuningSet

DropSqlTuningSet

DropSqlTuningTask

EnableAutomaticInitialPlanCapture

EnableAutomaticSpmEvolveAdvisorTask

EnableHighFrequencyAutomaticSpmEvolveAdvisorTask

EnableSqlPlanBaselinesUsage

FetchSqlTuningSet

GenerateAwrSnapshot

GetExecutionPlanStatsComparision

GetOptimizerStatisticsAdvisorExecution

GetOptimizerStatisticsAdvisorExecutionScript

GetOptimizerStatisticsCollectionOperation

GetSqlExecutionPlan

GetSqlPlanBaseline

GetSqlPlanBaselineConfiguration

GetSqlTuningAdvisorTaskSummaryReport

GetUser

ListAlertLogs

ListAttentionLogs

ListConsumerGroupPrivileges

ListCursorCacheStatements

ListDataAccessContainers

ListDatabaseParameters

ListObjectPrivileges

ListOptimizerStatisticsAdvisorExecutions

ListOptimizerStatisticsCollectionAggregations

ListOptimizerStatisticsCollectionOperations

ListProxiedForUsers

ListProxyUsers

ListRoles

ListSpmJobs

ListSqlPlanBaselines

ListSqlTuningAdvisorTaskFindings

ListSqlTuningAdvisorTaskRecommendations

ListSqlTuningAdvisorTasks

ListSqlTuningSets

ListSystemPrivileges

ListTableStatistics

ListUsers

LoadSqlPlanBaselinesFromAwr

LoadSqlPlanBaselinesFromCursorCache

LoadSqlTuningSet

ModifySnapshotSettings

ResetDatabaseParameters

RunHistoricAddm

SaveSqlTuningSetAs

ShrinkTablespace

StartSqlTuningTask

SummarizeSqlPlanBaselines

SummarizeSqlPlanBaselinesByLastExecution

UpdateManagedDatabase

UpdatePreferredCredential

UpdateTablespace

ValidateBasicFilter

AddManagedDatabaseToManagedDatabaseGroup (benötigt auch manage dbmgmt-managed-database-groups)

CreateJob (auch manage dbmgmt-jobs erforderlich)

CreateNamedCredential (benötigt auch manage dbmgmt-named-credentials)

ImplementOptimizerStatisticsAdvisorRecommendations (gibt auch manage dbmgmt-jobs an)

ListExternalListenerServices (benötigt auch read dbmgmt-external-dbsystems)

RemoveManagedDatabaseFromManagedDatabaseGroup (benötigt auch manage dbmgmt-managed-database-groups)

TestNamedCredential (benötigt auch read dbmgmt-named-credentials)

UpdateNamedCredential (benötigt auch use dbmgmt-named-credentials)

verwalten

BENUTZEN +

keine zusätzlichen

keiner

keiner

dbmgmt-private-endpoints

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListDbManagementPrivateEndpoints

keiner

gelesen

PRÜFEN +

DBMGMT_PRIVATE_ENDPOINT_READ

GetDbManagementPrivateEndpoint

keiner

verwenden

LESEN +

DBMGMT_PRIVATE_ENDPOINT_UPDATE

UpdateDbManagementPrivateEndpoint

keine

verwalten

USE +

DBMGMT_PRIVATE_ENDPOINT_CREATE

DBMGMT_PRIVATE_ENDPOINT_DELETE

DBMGMT_PRIVATE_ENDPOINT_MOVE

CreateDbManagementPrivateEndpoint

DeleteDbManagementPrivateEndpoint

ChangeDbManagementPrivateEndpointCompartment

keine

dbmgmt-work-requests

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests

keine

gelesen

UNTERSUCHEN +

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs

ListWorkRequestErrors

GetWorkRequest

keine

verwenden

LESEN +

keine zusätzlichen

keine

keine

verwalten

LESEN +

BENUTZEN +

keine zusätzlichen

keiner

keiner

dbmgmt-external-dbsystem-entdeckt

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_INSPECT

ListExternalDbSystemDiscoveries

keine

gelesen

UNTERSUCHEN +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

GetExternalDbSystemDiscovery

CreateExternalDbSystem (benötigt auch manage dbmgmt-external-dbsystems)

verwenden

LESEN +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchExternalDbSystemDiscovery

UpdateExternalDbSystemDiscovery

keine

verwalten

BENUTZEN +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_DELETE

CreateExternalDbSystemDiscovery

DeleteExternalDbSystemDiscovery

keine

dbmgmt-external-dbsystems

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmInstances

ListExternalAsms

ListExternalClusterInstances

ListExternalClusters

ListExternalDatabases

ListExternalDbHomes

ListExternalDbNodes

ListExternalDbSystemConnectors

ListExternalDbSystems

ListExternalListeners

keine

gelesen

PRÜFEN +

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalDbSystemConnectorConnectionStatus

GetExternalAsm

GetExternalAsmInstance

GetExternalAsmMetrics

GetExternalCluster

GetExternalClusterInstance

GetExternalClusterMetrics

GetExternalDbHome

GetExternalDbNode

GetExternalDbNodeMetrics

GetExternalDbSystem

GetExternalDbSystemAvailabilityMetrics

GetExternalDbSystemConnector

GetExternalListener

GetExternalListenerMetrics

ListExternalListenerServices (benötigt auch use dbmgmt-managed-databases)

verwenden

LESEN +

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_WRITE

DisableExternalDbSystemDatabaseManagement

DisableExternalDbSystemStackMonitoring

EnableExternalDbSystemDatabaseManagement

EnableExternalDbSystemStackMonitoring

GetExternalAsmConfiguration

ListExternalAsmDiskGroups

ListExternalAsmUsers

UpdateExternalAsm

UpdateExternalAsmInstance

UpdateExternalCluster

UpdateExternalClusterInstance

UpdateExternalDbHome

UpdateExternalDbNode

UpdateExternalDbSystem

UpdateExternalDbSystemConnector

UpdateExternalListener

keine

verwalten

BENUTZEN +

DBMGMT_EXTERNAL_DBSYSTEM_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DBMGMT_EXTERNAL_DBSYSTEM_MOVE

ChangeExternalDbSystemCompartment

CreateExternalDbSystemConnector

DeleteExternalDbSystem

DeleteExternalDbSystemConnector

CreateExternalDbSystem (benötigt auch read dbmgmt-external-dbsystem-discoveries)

dbmgmt-external-exadata

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataInfrastructures

ListExternalExadataStorageServerConnectors

ListExternalExadataStorageServers

keine

gelesen

PRÜFEN +

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalExadataStorageServerConnector

GetExternalExadataInfrastructure

GetExternalExadataStorageGrid

GetExternalExadataStorageServer

GetExternalExadataStorageServerConnector

keine

verwenden

LESEN +

DBMGMT_EXTERNAL_EXADATA_UPDATE

DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

DBMGMT_EXTERNAL_EXADATA_CONTENT_WRITE

DisableExternalExadataInfrastructureManagement

EnableExternalExadataInfrastructureManagement

GetIormPlan

GetOpenAlertHistory

GetTopSqlCpuActivity

UpdateExternalExadataInfrastructure

UpdateExternalExadataStorageServerConnector

keiner

verwalten

BENUTZEN +

DBMGMT_EXTERNAL_EXADATA_CREATE

DBMGMT_EXTERNAL_EXADATA_DELETE

DBMGMT_EXTERNAL_EXADATA_MOVE

ChangeExternalExadataInfrastructureCompartment

CreateExternalExadataInfrastructure

CreateExternalExadataStorageServerConnector

DeleteExternalExadataInfrastructure

DeleteExternalExadataStorageServerConnector

DiscoverExternalExadataInfrastructure

keiner

dbmgmt-namens-credentials

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNamedCredentials

keiner

gelesen

UNTERSUCHEN +

DBMGMT_NAMED_CREDENTIAL_READ

GetNamedCredential

TestNamedCredential (benötigt auch use dbmgmt-managed-databases)

verwenden

LESEN +

DBMGMT_NAMED_CREDENTIAL_UPDATE

keiner

UpdateNamedCredential (benötigt auch use dbmgmt-managed-databases)

verwalten

BENUTZEN +

DBMGMT_NAMED_CREDENTIAL_CREATE

DBMGMT_NAMED_CREDENTIAL_DELETE

DBMGMT_NAMED_CREDENTIAL_MOVE

ChangeNamedCredentialCompartment

DeleteNamedCredential

CreateNamedCredential (benötigt auch use dbmgmt-managed-databases)

dbmgmt-dblm-Wundbarkeit

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_DBLM_VUL_ASSESSMENT_INSPECT

ListVulnerabilityScans

keine

gelesen

PRÜFEN +

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerability

GetVulnerabilityScan

ListAggregatedVulnerabilityData

ListNotifications

ListVulnerabilities

ListVulnerabilityResources

keine

verwenden

LESEN +

keine zusätzlichen

keine

keine

verwalten

USE +

DBMGMT_DBLM_INGEST

DBMGMT_DBLM_VUL_ASSESSMENT_CREATE

DBMGMT_DBLM_VUL_ASSESSMENT_DELETE

DBMGMT_DBLM_VUL_ASSESSMENT_UPDATE

CreateVulnerabilityScan

Ingest

IngestError

IngestWorkDetails

keine

dbmgmt-dblm-workrequest

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestErrors

ListWorkRequestLogs

ListWorkRequests

keine

gelesen

PRÜFEN +

DBMGMT_DBLM_WORK_REQUEST_READ

GetWorkRequest

keine

verwenden

LESEN +

keine zusätzlichen

keine

keine

verwalten

USE +

keine zusätzlichen

keine

keine

dbmgmt-dblm-patch-mgmt

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

GetReleaseVersionDetail

ListDatabases

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

keine

gelesen

PRÜFEN +

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchInfoStore

GetPatchManagement

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

keine

verwenden

LESEN +

keine zusätzlichen

keine

keine

verwalten

USE +

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

DBMGMT_DBLM_PATCH_MANAGEMENT_DELETE

DBMGMT_DBLM_PATCH_MANAGEMENT_MOVE

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

AbortPatchOperation

ChangePatchOperationCompartment

CheckPatchConflict

CreateSoftwareImage

CreateSoftwareImageVersion

DeletePatchOperation

DeleteSoftwareImage

PatchResources

QuickValidations

RetryPatchOperation

UpdatePatchOperation

UpdateSoftwareImage

UpdateSoftwareImageVersion

ValidateMosCredentials

keine

dbmgmt-dblm-patch-operationen

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetReleaseVersionDetail

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

keine

gelesen

INSPECT +

DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchInfoStore

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

keine

verwenden

READ +

keine zusätzlichen

keine

keine

verwalten

USE +

DBMGMT_DBLM_INGEST

DBMGMT_DBLM_PATCH_OPERATION_CREATE

DBMGMT_DBLM_PATCH_OPERATION_DELETE

DBMGMT_DBLM_PATCH_OPERATION_MOVE

DBMGMT_DBLM_PATCH_OPERATION_UPDATE

AbortPatchOperation

ChangePatchOperationCompartment

DeletePatchOperation

Ingest

IngestError

IngestWorkDetails

PatchResources

QuickValidations

RetryPatchOperation

UpdatePatchOperation

keine

dbmgmt-sqlwatch-fleet

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_SPA_FLEET_INSPECT

keine

keine

gelesen

INSPECT +

DBMGMT_SPA_FLEET_READ

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchFleet

GetSqlWatchFleetComparison

ListSqlWatchFleetComparisons

keine

verwenden

READ +

DBMGMT_SPA_FLEET_DB_COMPARISON_UPDATE

UpdateSqlWatchFleetComparison

keine

verwalten

USE +

DBMGMT_SPA_FLEET_DB_COMPARISON_CREATE

DBMGMT_SPA_FLEET_DB_COMPARISON_DELETE

CreateSqlWatchFleetComparison

DeleteSqlWatchFleetComparison

keine

dbmgmt-sqlwatch-spa

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_SPA_TASK_INSPECT

ListSqlWatchTasks

keine

gelesen

INSPECT +

DBMGMT_SPA_TASK_READ

DBMGMT_SPA_TASK_TRIAL_READ

DBMGMT_SPA_TASK_COMPARISON_READ

GetSqlWatchTask

GetSqlWatchTaskComparison

GetSqlWatchTaskTrial

ListSqlWatchTaskComparisonParameters

ListSqlWatchTaskComparisons

ListSqlWatchTaskExecutionParameters

ListSqlWatchTaskExecutionTypes

ListSqlWatchTaskInitialParameters

ListSqlWatchTaskMetrics

ListSqlWatchTaskTrialParameters

ListSqlWatchTaskTrials

ListSqlWatchTaskTypes

ListSqlWatchTuningSets

SummarizeActionSummarizeLatestComparisons

SummarizeByStatus

SummarizeByType

keine

verwenden

READ +

DBMGMT_SPA_TASK_UPDATE

DBMGMT_SPA_TASK_INTERRUPT

DBMGMT_SPA_TASK_COMPLETE

DBMGMT_SPA_TASK_RESUME

CompleteSpaTask

InterruptSpaTask

ResumeSpaTask

UpdateSqlWatchTask

UpdateSqlWatchTaskComparison

UpdateSqlWatchTaskTrial

keine

verwalten

USE +

DBMGMT_SPA_TASK_CREATE

DBMGMT_SPA_TASK_DELETE

DBMGMT_SPA_TASK_TRIAL_CREATE

DBMGMT_SPA_TASK_TRIAL_DELETE

DBMGMT_SPA_TASK_COMPARISON_CREATE

DBMGMT_SPA_TASK_COMPARISON_DELETE

DBMGMT_SPA_TASK_PUBLISH_SQL_RESULT

CreateSqlWatchDbLink

CreateSqlWatchTask

CreateSqlWatchTaskComparison

CreateSqlWatchTaskTrial

DeleteSqlWatchDbLink

DeleteSqlWatchTask

DeleteSqlWatchTaskComparison

DeleteSqlWatchTaskTrial

GetSqlWatchDbLink

ListCreateLikeParameters

ListSqlWatchDbLinks

PublishSqlResult

UpdateSqlWatchDbLink

keine

dbmgmt-managed-mysql-databases

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabases

keine

gelesen

INSPECT +

DBMGMT_MANAGED_MYSQL_DB_READ

GetHeatWaveFleetMetric

GetManagedMySqlDatabase

GetMySqlFleetMetric

SummarizeManagedMySqlDatabaseAvailabilityMetrics

keine

verwenden

READ +

DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

DBMGMT_MANAGED_MYSQL_DB_UPDATE

ChangeMysqlDatabaseManagementType

GetBinaryLogInformation

GetGeneralReplicationInformation

GetMySqlQueryDetails

ListHighAvailabilityMembers

ListInboundReplications

ListManagedMySqlDatabaseConfigurationData

ListManagedMySqlDatabaseSqlData

ListMySqlDigestErrors

ListOutboundReplications

keine

verwalten

USE +

keine zusätzlichen

keine

keine

dbmgmt-external-mysql-databases

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListExternalMySqlDatabases

keine

gelesen

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_READ

GetExternalMySqlDatabase

CheckExternalMySqlDatabaseConnectorConnectionStatus (erfordert auch use dbmgmt-external-mysql-database-connectors)

verwenden

READ +

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE

UpdateExternalMysqlDatabase

CreateExternalMySqlDatabaseConnector (erfordert auch manage dbmgmt-external-mysql-database-connectors)

DeleteExternalMySqlDatabaseConnector (erfordert auch manage dbmgmt-external-mysql-database-connectors)

DisableExternalMySqlDatabaseManagement (erfordert auch use dbmgmt-external-mysql-database-connectors)

EnableExternalMySqlDatabaseManagement (erfordert auch use dbmgmt-external-mysql-database-connectors)

verwalten

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_DELETE

CreateExternalMySqlDatabase

DeleteExternalMySqlDatabase

keine

dbmgmt-external-mysql-database-connectors

Verbs Berechtigungen Vollständig abgedeckte APIs Teilweise abgedeckte APIs

inspect

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDatabaseConnectors

keine

gelesen

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_READ

GetExternalMySqlDatabaseConnector

keine

verwenden

READ +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

UpdateExternalMysqlDatabaseConnector

CheckExternalMySqlDatabaseConnectorConnectionStatus (erfordert auch read dbmgmt-external-mysql-databases)

DisableExternalMySqlDatabaseManagement (erfordert auch use dbmgmt-external-mysql-databases)

EnableExternalMySqlDatabaseManagement (erfordert auch use dbmgmt-external-mysql-databases)

verwalten

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_DELETE

keine

CreateExternalMySqlDatabaseConnector (erfordert auch use dbmgmt-external-mysql-databases)

DeleteExternalMySqlDatabaseConnector (erfordert auch use dbmgmt-external-mysql-databases)

Für jeden API-Vorgang erforderliche Berechtigungen

In der folgenden Tabelle sind die API-Vorgänge in alphabetischer Reihenfolge aufgeführt.

Hinweis

Wenn Sie benannte Zugangsdaten verwenden, um einen API-Vorgang für Diagnose und Management für Oracle-Datenbanken und externe Datenbanksysteme auszuführen, ist die Berechtigung DBMGMT_NAMED_CREDENTIAL_READ möglicherweise zusätzlich zu den Berechtigungen erforderlich, die für den API-Vorgang aufgeführt sind.

Informationen zu Berechtigungen finden Sie unter Berechtigungen.

API-Vorgänge Für den Vorgang erforderliche Berechtigungen

AbortPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE oder DBMGMT_DBLM_PATCH_OPERATION_UPDATE

AddManagedDatabaseToManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_ADD_DATABASE und DBMGMT_MANAGED_DB_UPDATE

AddmTasks

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ChangeDatabaseParameters

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeDatafiles

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeDbManagementPrivateEndpointCompartment

DBMGMT_PRIVATE_ENDPOINT_MOVE

ChangeExternalDbSystemCompartment

DBMGMT_EXTERNAL_DBSYSTEM_MOVE

ChangeExternalExadataInfrastructureCompartment

DBMGMT_EXTERNAL_EXADATA_MOVE

ChangeJobCompartment

DBMGMT_JOB_MOVE

ChangeManagedDatabaseGroupCompartment

DBMGMT_MANAGED_DB_GROUP_MOVE

ChangeMysqlDatabaseManagementType

DBMGMT_MANAGED_MYSQL_DB_UPDATE

ChangeNamedCredentialCompartment

DBMGMT_NAMED_CREDENTIAL_MOVE

ChangePatchOperationCompartment

DBMGMT_DBLM_PATCH_MANAGEMENT_MOVE oder DBMGMT_DBLM_PATCH_OPERATION_MOVE

ChangePlanRetention

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSpaceBudget

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSqlPlanBaselinesAttributes

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CheckExternalDbSystemConnectorConnectionStatus

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalMySqlDatabaseConnectorConnectionStatus

DBMGMT_EXTERNAL_MYSQL_DB_READ und DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

CheckPatchConflict

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CloneSqlTuningTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CoalesceTablespace

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CompleteSpaTask

DBMGMT_SPA_TASK_COMPLETE

ConfigureAutomaticCaptureFilters

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ConfigureAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CreateDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_CREATE

CreateExternalDbSystem

DBMGMT_EXTERNAL_DBSYSTEM_CREATE und DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

CreateExternalDbSystemConnector

DBMGMT_EXTERNAL_DBSYSTEM_CREATE

CreateExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_CREATE

CreateExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_CREATE

CreateExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_CREATE

CreateExternalMySqlDatabase

DBMGMT_EXTERNAL_MYSQL_DB_CREATE

CreateExternalMySqlDatabaseConnector

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE und DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

CreateJob

Die erforderlichen Berechtigungen hängen vom SQL-Typ für SQL-Jobs und vom Ressourcentyp ab.

  • Abfrage: Neben der Berechtigung DBMGMT_JOB_CREATE ist die folgende CONTENT_READ-Berechtigung erforderlich:
    • Für eine verwaltete Datenbank: DBMGMT_MANAGED_DB_CONTENT_READ
    • Für eine Datenbankgruppe: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ
  • DDL/DML/PLSQL: Neben der Berechtigung DBMGMT_JOB_CREATE sind die folgenden CONTENT_READ- und CONTENT_WRITE-Berechtigungen erforderlich:
    • Für eine verwaltete Datenbank: DBMGMT_MANAGED_DB_CONTENT_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE
    • Für eine Datenbankgruppe: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ und DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

CreateManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_CREATE

CreateNamedCredential

DBMGMT_NAMED_CREDENTIAL_CREATE, DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

CreateSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CreateSoftwareImageVersion

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

CreateSqlTuningSet

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CreateSqlWatchDbLink

DBMGMT_SPA_TASK_CREATE

CreateSqlWatchFleetComparison

DBMGMT_SPA_FLEET_DB_COMPARISON_CREATE

CreateSqlWatchTask

DBMGMT_SPA_TASK_CREATE

CreateSqlWatchTaskComparison

DBMGMT_SPA_TASK_COMPARISON_CREATE

CreateSqlWatchTaskTrial

DBMGMT_SPA_TASK_TRIAL_CREATE

CreateTablespace

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

CreateVulnerabilityScan

DBMGMT_DBLM_VUL_ASSESSMENT_CREATE

DeleteDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_DELETE

DeleteExternalDbSystem

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DeleteExternalDbSystemConnector

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DeleteExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_DELETE

DeleteExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_DELETE

DeleteExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_DELETE

DeleteExternalMySqlDatabase

DBMGMT_EXTERNAL_MYSQL_DB_DELETE

DeleteExternalMySqlDatabaseConnector

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE und DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_DELETE

DeleteJob

DBMGMT_JOB_DELETE

DeleteManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_DELETE

DeleteNamedCredential

DBMGMT_NAMED_CREDENTIAL_DELETE

DeletePatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_DELETE oder DBMGMT_DBLM_PATCH_OPERATION_DELETE

DeletePreferredCredential

DBMGMT_MANAGED_DB_UPDATE

DeleteSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_DELETE

DeleteSqlWatchDbLink

DBMGMT_SPA_TASK_CREATE

DeleteSqlWatchFleetComparison

DBMGMT_SPA_FLEET_DB_COMPARISON_DELETE

DeleteSqlWatchTask

DBMGMT_SPA_TASK_DELETE

DeleteSqlWatchTaskComparison

DBMGMT_SPA_TASK_COMPARISON_DELETE

DeleteSqlWatchTaskTrial

DBMGMT_SPA_TASK_TRIAL_DELETE

DeleteTablespace

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableExternalDbSystemDatabaseManagement

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

DisableExternalDbSystemStackMonitoring

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

DisableExternalExadataInfrastructureManagement

DBMGMT_EXTERNAL_EXADATA_UPDATE

DisableExternalMySqlDatabaseManagement

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE und DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

DisableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DiscoverExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_CREATE

DropSqlPlanBaselines

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlsInSqlTuningSet

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningSet

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableExternalDbSystemDatabaseManagement

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

EnableExternalDbSystemStackMonitoring

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

EnableExternalExadataInfrastructureManagement

DBMGMT_EXTERNAL_EXADATA_UPDATE

EnableExternalMySqlDatabaseManagement

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE und DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

EnableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

FetchSqlTuningSet

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GenerateAwrSnapshot

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

GetAwrDbReport

DBMGMT_MANAGED_DB_READ

GetAwrDbSqlReport

DBMGMT_MANAGED_DB_READ

GetBinaryLogInformation

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetClusterCacheMetric

DBMGMT_MANAGED_DB_READ

GetDatabaseFleetBackupMetrics

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einem bestimmten Compartment: DBMGMT_MANAGED_DB_READ

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einer bestimmten Datenbankgruppe: DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetDataguardMetrics

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einem bestimmten Compartment: DBMGMT_MANAGED_DB_READ

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einer bestimmten Datenbankgruppe: DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHaOverviewMetrics

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einem bestimmten Compartment: DBMGMT_MANAGED_DB_READ

  • Für eine Flotte von High Availability-verwalteten Datenbanken in einer bestimmten Datenbankgruppe: DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHealthMetrics

  • Für eine Flotte von verwalteten Datenbanken in einem bestimmten Compartment: DBMGMT_MANAGED_DB_READ

  • Für eine Flotte von verwalteten Datenbanken in einer bestimmten Datenbankgruppe: DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseHaBackupDetails

DBMGMT_MANAGED_DB_READ

GetDatabaseHomeMetrics

DBMGMT_MANAGED_DB_READ

GetDataguardPerformanceMetrics

DBMGMT_MANAGED_DB_READ

GetDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_READ

GetExecutionPlanStatsComparision

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetExternalAsm

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalAsmConfiguration

DBMGMT_EXTERNAL_DBSYSTEM_READ und DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

GetExternalAsmInstance

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalAsmMetrics

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalCluster

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalClusterInstance

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalClusterMetrics

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbHome

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbNode

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbNodeMetrics

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbSystem

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbSystemAvailabilityMetrics

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbSystemConnector

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

GetExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_READ

GetExternalExadataStorageGrid

DBMGMT_EXTERNAL_EXADATA_READ

GetExternalExadataStorageServer

DBMGMT_EXTERNAL_EXADATA_READ

GetExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_READ

GetExternalListener

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalListenerMetrics

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalMySqlDatabase

DBMGMT_EXTERNAL_MYSQL_DB_READ

GetExternalMySqlDatabaseConnector

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_READ

GetGeneralReplicationInformation

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetHeatWaveFleetMetric

DBMGMT_MANAGED_MYSQL_DB_READ

GetIormPlan

DBMGMT_EXTERNAL_EXADATA_READ und DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetJob

DBMGMT_JOB_READ

GetJobExecution

DBMGMT_JOB_READ

GetJobRun

DBMGMT_JOB_READ

GetManagedDatabase

DBMGMT_MANAGED_DB_READ

GetManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_READ

GetManagedMySqlDatabase

DBMGMT_MANAGED_MYSQL_DB_READ

GetMySqlFleetMetric

DBMGMT_MANAGED_MYSQL_DB_READ

GetMySqlQueryDetails

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ

GetOpenAlertHistory

DBMGMT_EXTERNAL_EXADATA_READ und DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetOptimizerStatisticsAdvisorExecution

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsAdvisorExecutionScript

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsCollectionOperation

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetPatchInfoStore

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchManagement

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTask

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTaskStep

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

GetPdbMetrics

DBMGMT_MANAGED_DB_READ

GetPeerDatabaseMetrics

DBMGMT_MANAGED_DB_READ

GetPreferredCredential

DBMGMT_MANAGED_DB_READ

GetReleaseVersionDetail

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT oder DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

GetSqlExecutionPlan

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlPlanBaseline

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlPlanBaselineConfiguration

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlTuningAdvisorTaskSummaryReport

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlWatchDbLink

DBMGMT_SPA_TASK_CREATE

GetSqlWatchFleet

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchFleetComparison

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchTask

DBMGMT_SPA_TASK_READ

GetSqlWatchTaskComparison

DBMGMT_SPA_TASK_READ

GetSqlWatchTaskTrial

DBMGMT_SPA_TASK_READ

GetTablespace

DBMGMT_MANAGED_DB_READ

GetTopSqlCpuActivity

DBMGMT_EXTERNAL_EXADATA_READ und DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetUser

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

GetVulnerability

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerabilityScan

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetWorkRequest

DBMGMT_WORK_REQUEST_READ

GetWorkRequest (für die Erkennung von Sicherheitslücken)

DBMGMT_DBLM_WORK_REQUEST_READ

ImplementOptimizerStatisticsAdvisorRecommendations

DBMGMT_MANAGED_DB_READ, DBMGMT_MANAGED_DB_CONTENT_READ, DBMGMT_MANAGED_DB_CONTENT_WRITE und DBMGMT_JOB_CREATE

Ingest

DBMGMT_DBLM_INGEST

IngestError

DBMGMT_DBLM_INGEST

IngestWorkDetails

DBMGMT_DBLM_INGEST

InterruptSpaTask

DBMGMT_SPA_TASK_INTERRUPT

ListAggregatedVulnerabilityData

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListAlertLogs

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListAttentionLogs

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListAwrDbs

DBMGMT_MANAGED_DB_READ

ListAwrDbSnapshots

DBMGMT_MANAGED_DB_READ

ListConsumerGroupPrivileges

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListCreateLikeParameters

DBMGMT_SPA_TASK_TRIAL_CREATE

ListCursorCacheStatements

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListDataAccessContainers

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabaseParameters

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabases

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

ListDbManagementPrivateEndpoints

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListExternalAsmDiskGroups

DBMGMT_EXTERNAL_DBSYSTEM_READ und DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

ListExternalAsmInstances

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsms

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmUsers

DBMGMT_EXTERNAL_DBSYSTEM_READ und DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

ListExternalClusterInstances

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalClusters

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalDatabases

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalDbHomes

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalDbNodes

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalDbSystemConnectors

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalDbSystemDiscoveries

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_INSPECT

ListExternalDbSystems

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalExadataInfrastructures

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataStorageServerConnectors

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataStorageServers

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalListeners

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalListenerServices

DBMGMT_EXTERNAL_DBSYSTEM_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListExternalMySqlDatabases

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListHighAvailabilityMembers

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListInboundReplications

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListJobExecutions

DBMGMT_JOB_READ

ListJobRuns

DBMGMT_JOB_READ

ListJobs

DBMGMT_JOB_INSPECT

ListManagedDatabaseGroups

DBMGMT_MANAGED_DB_GROUP_INSPECT

ListManagedDatabases

DBMGMT_MANAGED_DB_INSPECT

ListManagedMySqlDatabaseConfigurationData

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListManagedMySqlDatabases

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabaseSqlData

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListMySqlDatabaseConnectors

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDigestErrors

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListNamedCredentials

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNotifications

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListObjectPrivileges

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsAdvisorExecutions

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionAggregations

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionOperations

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListOutboundReplications

DBMGMT_MANAGED_MYSQL_DB_READ und DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListPatchOperations

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT oder DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTasks

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT oder DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTaskSteps

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT oder DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPreferredCredentials

DBMGMT_MANAGED_DB_READ

ListProxiedForUsers

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListProxyUsers

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListRoles

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSoftwareImages

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT oder DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListSpmJobs

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlPlanBaselines

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskFindings

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskRecommendations

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTasks

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningSets

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlWatchDbLinks

DBMGMT_SPA_TASK_CREATE

ListSqlWatchFleetComparisons

DBMGMT_SPA_FLEET_DB_READ

ListSqlWatchTaskComparisonParameters

DBMGMT_SPA_TASK_READ

ListSqlWatchTaskComparisons

DBMGMT_SPA_TASK_COMPARISON_READ

ListSqlWatchTaskExecutionParameters

DBMGMT_SPA_TASK_READ

ListSqlWatchTaskExecutionTypes

DBMGMT_SPA_TASK_READ

ListSqlWatchTaskInitialParameters

DBMGMT_SPA_TASK_READ

ListSqlWatchTaskMetrics

DBMGMT_SPA_TASK_READ

ListSqlWatchTasks

DBMGMT_SPA_TASK_INSPECT

ListSqlWatchTaskTrialParameters

DBMGMT_SPA_TASK_READ

ListSqlWatchTaskTrials

DBMGMT_SPA_TASK_TRIAL_READ

ListSqlWatchTaskTypes

DBMGMT_SPA_TASK_READ

ListSqlWatchTuningSets

DBMGMT_SPA_TASK_READ

ListSystemPrivileges

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListTablespaces

DBMGMT_MANAGED_DB_READ

ListTableStatistics

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListUsers

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ListVulnerabilities

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListVulnerabilityResources

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListVulnerabilityScans

DBMGMT_DBLM_VUL_ASSESSMENT_INSPECT

ListWorkRequestErrors

DBMGMT_WORK_REQUEST_READ

ListWorkRequestErrors (für die Erkennung von Sicherheitslücken)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestLogs

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs (für die Erkennung von Sicherheitslücken)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequests

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests (für die Erkennung von Sicherheitslücken)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

LoadSqlPlanBaselinesFromAwr

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlPlanBaselinesFromCursorCache

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlTuningSet

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ModifySnapshotSettings

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

PatchExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchResources

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE oder DBMGMT_DBLM_PATCH_OPERATION_CREATE

PublishSqlResult

DBMGMT_SPA_TASK_PUBLISH_SQL_RESULT

QuickValidations

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE oder DBMGMT_DBLM_PATCH_OPERATION_CREATE

RemoveManagedDatabaseFromManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_REMOVE_DATABASE und DBMGMT_MANAGED_DB_UPDATE

ResetDatabaseParameters

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ResumeSpaTask

DBMGMT_SPA_TASK_RESUME

RetryPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE oder DBMGMT_DBLM_PATCH_OPERATION_UPDATE

RunHistoricAddm

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

SaveSqlTuningSetAs

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ShrinkTablespace

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

StartSqlTuningTask

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

Subscribe

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

SummarizeActionSummarizeLatestComparisons

DBMGMT_SPA_TASK_READ

SummarizeAwrDbCpuUsages

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbMetrics

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbParameterChanges

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbParameters

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbSnapshotRanges

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbSysstats

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbTopWaitEvents

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbWaitEventBuckets

DBMGMT_MANAGED_DB_READ

SummarizeAwrDbWaitEvents

DBMGMT_MANAGED_DB_READ

SummarizeByStatus

DBMGMT_SPA_TASK_READ

SummarizeByType

DBMGMT_SPA_TASK_READ

SummarizeJobExecutionsStatuses

DBMGMT_JOB_READ

SummarizeManagedMySqlDatabaseAvailabilityMetrics

DBMGMT_MANAGED_MYSQL_DB_READ

SummarizeSqlPlanBaselines

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

SummarizeSqlPlanBaselinesByLastExecution

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

TestNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ, DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

TestPreferredCredential

DBMGMT_MANAGED_DB_READ

Unsubscribe

DBMGMT_DBLM_PATCH_MANAGEMENT_READ oder DBMGMT_DBLM_PATCH_OPERATION_READ

UpdateDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_UPDATE

UpdateExternalAsm

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalAsmInstance

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalCluster

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalClusterInstance

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalDbHome

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalDbNode

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalDbSystem

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalDbSystemConnector

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

UpdateExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_UPDATE

UpdateExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_UPDATE

UpdateExternalListener

DBMGMT_EXTERNAL_DBSYSTEM_UPDATE

UpdateExternalMysqlDatabase

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE

UpdateExternalMysqlDatabaseConnector

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

UpdateJob

DBMGMT_JOB_UPDATE

UpdateManagedDatabase

DBMGMT_MANAGED_DB_UPDATE

UpdateManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_UPDATE

UpdateNamedCredential

DBMGMT_NAMED_CREDENTIAL_UPDATE, DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

UpdatePatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE oder DBMGMT_DBLM_PATCH_OPERATION_UPDATE

UpdatePreferredCredential

DBMGMT_MANAGED_DB_UPDATE

UpdateSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

UpdateSoftwareImageVersion

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

UpdateSqlWatchDbLink

DBMGMT_SPA_TASK_CREATE

UpdateSqlWatchFleetComparison

DBMGMT_SPA_FLEET_DB_COMPARISON_UPDATE

UpdateSqlWatchTask

DBMGMT_SPA_TASK_UPDATE

UpdateSqlWatchTaskComparison

DBMGMT_SPA_TASK_UPDATE

UpdateSqlWatchTaskTrial

DBMGMT_SPA_TASK_UPDATE

UpdateTablespace

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_WRITE

ValidateBasicFilter

DBMGMT_MANAGED_DB_READ und DBMGMT_MANAGED_DB_CONTENT_READ

ValidateMosCredentials

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE