Dettagli dei criteri di Database Management

Gli argomenti di questa sezione forniscono dettagli per la scrittura dei criteri IAM (Oracle Cloud Infrastructure Identity and Access Management) per controllare l'accesso al servizio Gestione database.

Di seguito sono riportate informazioni dettagliate ed esempi dei criteri necessari per utilizzare Gestione database.

Resource-types

Oracle Database, sistema di database esterno e tipi di risorse dell'infrastruttura Exadata

Tipi di risorsa aggregati

dbmgmt-family

dbmgmt-dblm-family

Nota

Il tipo di risorsa aggregato dbmgmt-family include tutti i singoli tipi di risorsa Gestione database e il tipo di risorsa aggregato dbmgmt-dblm-family, che a sua volta include i tipi di risorsa individuali riportati di seguito.
  • dbmgmt-dblm-vulnerability
  • dbmgmt-dblm-workrequest
  • dbmgmt-dblm-patch-mgmt
  • dbmgmt-dblm-patch-operations

Singoli tipi di risorsa

  • 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

Tipi di risorse del sistema DB HeatWave ed esterno MySQL

Tipo di risorsa aggregata

dbmgmt-mysql-family

Tipo di risorsa individuale

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

commenti

Un criterio che utilizza <verb> dbmgmt-family equivale a scriverne uno con un'istruzione <verb> <individual resource-type> separata per ciascuno dei singoli tipi di risorsa della famiglia.

Per i dettagli delle operazioni API coperte da ciascun verbo, per ogni singolo tipo di risorsa, vedere le tabelle in Dettagli per le combinazioni verbo-tipo di risorsa.

Variabili supportate

Sono supportate solo variabili generali. Per informazioni, vedere Variabili generali per tutte le richieste.

Dettagli per le combinazioni verbo-tipo di risorsa

Le tabelle seguenti mostrano le autorizzazioni e le operazioni API coperte da ciascun verbo. Il livello di accesso è cumulativo quando si sceglie inspect > read > use > manage. Un segno più (+) in una cella di tabella indica l'accesso incrementale rispetto alla cella direttamente sopra di essa, mentre "nessun extra" indica nessun accesso incrementale.

dbmgmt-lavori

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_JOB_INSPECT

ListJobs

nessuno

letto

ISPEZIONA +

DBMGMT_JOB_READ

GetJob

ListJobRuns

GetJobRun

ListJobExecutions

GetJobExecution

SummarizeJobExecutionsStatuses

nessuno

utilizzare

LETTURA +

nessun altro

nessuno

nessuno

gestisci

USE +

DBMGMT_JOB_CREATE

DBMGMT_JOB_DELETE

DBMGMT_JOB_MOVE

DBMGMT_JOB_UPDATE

ChangeJobCompartment

DeleteJob

UpdateJob

CreateJob (ha bisogno anche di use dbmgmt-managed-database-groups o use dbmgmt-managed-databases)

ImplementOptimizerStatisticsAdvisorRecommendations (ha bisogno anche di use dbmgmt-managed-databases)

gruppi di database gestiti da dbmgmt

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_MANAGED_DB_GROUP_INSPECT

ListManagedDatabaseGroups

nessuno

letto

ISPEZIONA +

DBMGMT_MANAGED_DB_GROUP_READ

GetManagedDatabaseGroup

GetDatabaseFleetBackupMetrics (ha bisogno anche di read dbmgmt-managed-databases)

GetDatabaseFleetDataguardMetrics (ha bisogno anche di read dbmgmt-managed-databases)

GetDatabaseFleetHaOverviewMetrics (ha bisogno anche di read dbmgmt-managed-databases)

GetDatabaseFleetHealthMetrics (ha bisogno anche di read dbmgmt-managed-databases)

utilizzare

LETTURA +

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

DBMGMT_MANAGED_DB_GROUP_UPDATE

UpdateManagedDatabaseGroup

CreateJob (ha bisogno anche di manage dbmgmt-jobs)

gestisci

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 (ha bisogno anche di use dbmgmt-managed-databases)

RemoveManagedDatabaseFromManagedDatabaseGroup (ha bisogno anche di use dbmgmt-managed-databases)

database gestiti da dbmgmt

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_MANAGED_DB_INSPECT

ListManagedDatabases

nessuno

letto

ISPEZIONA +

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

nessuno

utilizzare

LETTURA +

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 (ha bisogno anche di manage dbmgmt-managed-database-groups)

CreateJob (ha bisogno anche di manage dbmgmt-jobs)

CreateNamedCredential (ha bisogno anche di manage dbmgmt-named-credentials)

ImplementOptimizerStatisticsAdvisorRecommendations (ha bisogno anche di manage dbmgmt-jobs)

ListExternalListenerServices (ha bisogno anche di read dbmgmt-external-dbsystems)

RemoveManagedDatabaseFromManagedDatabaseGroup (ha bisogno anche di manage dbmgmt-managed-database-groups)

TestNamedCredential (ha bisogno anche di read dbmgmt-named-credentials)

UpdateNamedCredential (ha bisogno anche di use dbmgmt-named-credentials)

gestisci

USE +

nessun altro

nessuno

nessuno

dbmgmt-endpoint privati

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListDbManagementPrivateEndpoints

nessuno

letto

ISPEZIONA +

DBMGMT_PRIVATE_ENDPOINT_READ

GetDbManagementPrivateEndpoint

nessuno

utilizzare

LETTURA +

DBMGMT_PRIVATE_ENDPOINT_UPDATE

UpdateDbManagementPrivateEndpoint

nessuno

gestisci

USE +

DBMGMT_PRIVATE_ENDPOINT_CREATE

DBMGMT_PRIVATE_ENDPOINT_DELETE

DBMGMT_PRIVATE_ENDPOINT_MOVE

CreateDbManagementPrivateEndpoint

DeleteDbManagementPrivateEndpoint

ChangeDbManagementPrivateEndpointCompartment

nessuno

dbmgmt-richieste di lavoro

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests

nessuno

letto

ISPEZIONA +

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs

ListWorkRequestErrors

GetWorkRequest

nessuno

utilizzare

LETTURA +

nessun altro

nessuno

nessuno

gestisci

LETTURA +

UTILIZZO +

nessun altro

nessuno

nessuno

dbmgmt-esterna-dbsystem-scoperte

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_INSPECT

ListExternalDbSystemDiscoveries

nessuno

letto

ISPEZIONA +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

GetExternalDbSystemDiscovery

CreateExternalDbSystem (ha bisogno anche di manage dbmgmt-external-dbsystems)

utilizzare

LETTURA +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchExternalDbSystemDiscovery

UpdateExternalDbSystemDiscovery

nessuno

gestisci

USE +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_DELETE

CreateExternalDbSystemDiscovery

DeleteExternalDbSystemDiscovery

nessuno

dbmgmt-dbsystems esterni

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmInstances

ListExternalAsms

ListExternalClusterInstances

ListExternalClusters

ListExternalDatabases

ListExternalDbHomes

ListExternalDbNodes

ListExternalDbSystemConnectors

ListExternalDbSystems

ListExternalListeners

nessuno

letto

ISPEZIONA +

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalDbSystemConnectorConnectionStatus

GetExternalAsm

GetExternalAsmInstance

GetExternalAsmMetrics

GetExternalCluster

GetExternalClusterInstance

GetExternalClusterMetrics

GetExternalDbHome

GetExternalDbNode

GetExternalDbNodeMetrics

GetExternalDbSystem

GetExternalDbSystemAvailabilityMetrics

GetExternalDbSystemConnector

GetExternalListener

GetExternalListenerMetrics

ListExternalListenerServices (ha bisogno anche di use dbmgmt-managed-databases)

utilizzare

LETTURA +

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

nessuno

gestisci

USE +

DBMGMT_EXTERNAL_DBSYSTEM_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DBMGMT_EXTERNAL_DBSYSTEM_MOVE

ChangeExternalDbSystemCompartment

CreateExternalDbSystemConnector

DeleteExternalDbSystem

DeleteExternalDbSystemConnector

CreateExternalDbSystem (ha bisogno anche di read dbmgmt-external-dbsystem-discoveries)

dbmgmt-external-exadata

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataInfrastructures

ListExternalExadataStorageServerConnectors

ListExternalExadataStorageServers

nessuno

letto

ISPEZIONA +

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalExadataStorageServerConnector

GetExternalExadataInfrastructure

GetExternalExadataStorageGrid

GetExternalExadataStorageServer

GetExternalExadataStorageServerConnector

nessuno

utilizzare

LETTURA +

DBMGMT_EXTERNAL_EXADATA_UPDATE

DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

DBMGMT_EXTERNAL_EXADATA_CONTENT_WRITE

DisableExternalExadataInfrastructureManagement

EnableExternalExadataInfrastructureManagement

GetIormPlan

GetOpenAlertHistory

GetTopSqlCpuActivity

UpdateExternalExadataInfrastructure

UpdateExternalExadataStorageServerConnector

nessuno

gestisci

USE +

DBMGMT_EXTERNAL_EXADATA_CREATE

DBMGMT_EXTERNAL_EXADATA_DELETE

DBMGMT_EXTERNAL_EXADATA_MOVE

ChangeExternalExadataInfrastructureCompartment

CreateExternalExadataInfrastructure

CreateExternalExadataStorageServerConnector

DeleteExternalExadataInfrastructure

DeleteExternalExadataStorageServerConnector

DiscoverExternalExadataInfrastructure

nessuno

credenziali denominate in dbmgmt

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNamedCredentials

nessuno

letto

ISPEZIONA +

DBMGMT_NAMED_CREDENTIAL_READ

GetNamedCredential

TestNamedCredential (ha bisogno anche di use dbmgmt-managed-databases)

utilizzare

LETTURA +

DBMGMT_NAMED_CREDENTIAL_UPDATE

nessuno

UpdateNamedCredential (ha bisogno anche di use dbmgmt-managed-databases)

gestisci

UTILIZZO +

DBMGMT_NAMED_CREDENTIAL_CREATE

DBMGMT_NAMED_CREDENTIAL_DELETE

DBMGMT_NAMED_CREDENTIAL_MOVE

ChangeNamedCredentialCompartment

DeleteNamedCredential

CreateNamedCredential (ha bisogno anche di use dbmgmt-managed-databases)

dbmgmt-dblm-vulnerabilità

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_DBLM_VUL_ASSESSMENT_INSPECT

ListVulnerabilityScans

nessuno

letto

ISPEZIONA +

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerability

GetVulnerabilityScan

ListAggregatedVulnerabilityData

ListNotifications

ListVulnerabilities

ListVulnerabilityResources

nessuno

utilizzare

LETTURA +

nessun altro

nessuno

nessuno

gestisci

USE +

DBMGMT_DBLM_INGEST

DBMGMT_DBLM_VUL_ASSESSMENT_CREATE

DBMGMT_DBLM_VUL_ASSESSMENT_DELETE

DBMGMT_DBLM_VUL_ASSESSMENT_UPDATE

CreateVulnerabilityScan

Ingest

IngestError

IngestWorkDetails

nessuno

dbmgmt-dblm-workrequest

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestErrors

ListWorkRequestLogs

ListWorkRequests

nessuno

letto

ISPEZIONA +

DBMGMT_DBLM_WORK_REQUEST_READ

GetWorkRequest

nessuno

utilizzare

LETTO +

nessun altro

nessuno

nessuno

gestisci

USE +

nessun altro

nessuno

nessuno

dbmgmt-dblm-patch-mgmt

Verbi Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

GetReleaseVersionDetail

ListDatabases

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

nessuno

letto

ISPEZIONA +

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchInfoStore

GetPatchManagement

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

nessuno

utilizzare

LETTO +

nessun altro

nessuno

nessuno

gestisci

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

nessuno

dbmgmt-dblm-patch-operations

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetReleaseVersionDetail

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

nessuno

letto

ISPEZIONA +

DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchInfoStore

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

nessuno

utilizzare

LETTO +

nessun altro

nessuno

nessuno

gestisci

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

nessuno

dbmgmt-sqlwatch-flotta

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_SPA_FLEET_INSPECT

nessuno

nessuno

letto

ISPEZIONA +

DBMGMT_SPA_FLEET_READ

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchFleet

GetSqlWatchFleetComparison

ListSqlWatchFleetComparisons

nessuno

utilizzare

LETTO +

DBMGMT_SPA_FLEET_DB_COMPARISON_UPDATE

UpdateSqlWatchFleetComparison

nessuno

gestisci

USE +

DBMGMT_SPA_FLEET_DB_COMPARISON_CREATE

DBMGMT_SPA_FLEET_DB_COMPARISON_DELETE

CreateSqlWatchFleetComparison

DeleteSqlWatchFleetComparison

nessuno

dbmgmt-sqlwatch-spa

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_SPA_TASK_INSPECT

ListSqlWatchTasks

nessuno

letto

ISPEZIONA +

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

nessuno

utilizzare

LETTO +

DBMGMT_SPA_TASK_UPDATE

DBMGMT_SPA_TASK_INTERRUPT

DBMGMT_SPA_TASK_COMPLETE

DBMGMT_SPA_TASK_RESUME

CompleteSpaTask

InterruptSpaTask

ResumeSpaTask

UpdateSqlWatchTask

UpdateSqlWatchTaskComparison

UpdateSqlWatchTaskTrial

nessuno

gestisci

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

nessuno

database mysql gestiti da dbmgmt

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabases

nessuno

letto

ISPEZIONA +

DBMGMT_MANAGED_MYSQL_DB_READ

GetHeatWaveFleetMetric

GetManagedMySqlDatabase

GetMySqlFleetMetric

SummarizeManagedMySqlDatabaseAvailabilityMetrics

nessuno

utilizzare

LETTO +

DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

DBMGMT_MANAGED_MYSQL_DB_UPDATE

ChangeMysqlDatabaseManagementType

GetBinaryLogInformation

GetGeneralReplicationInformation

GetMySqlQueryDetails

ListHighAvailabilityMembers

ListInboundReplications

ListManagedMySqlDatabaseConfigurationData

ListManagedMySqlDatabaseSqlData

ListMySqlDigestErrors

ListOutboundReplications

nessuno

gestisci

USE +

nessun altro

nessuno

nessuno

database dbmgmt-external-mysql

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListExternalMySqlDatabases

nessuno

letto

ISPEZIONA +

DBMGMT_EXTERNAL_MYSQL_DB_READ

GetExternalMySqlDatabase

CheckExternalMySqlDatabaseConnectorConnectionStatus (ha bisogno anche di use dbmgmt-external-mysql-database-connectors)

utilizzare

LETTO +

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE

UpdateExternalMysqlDatabase

CreateExternalMySqlDatabaseConnector (ha bisogno anche di manage dbmgmt-external-mysql-database-connectors)

DeleteExternalMySqlDatabaseConnector (ha bisogno anche di manage dbmgmt-external-mysql-database-connectors)

DisableExternalMySqlDatabaseManagement (ha bisogno anche di use dbmgmt-external-mysql-database-connectors)

EnableExternalMySqlDatabaseManagement (ha bisogno anche di use dbmgmt-external-mysql-database-connectors)

gestisci

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_DELETE

CreateExternalMySqlDatabase

DeleteExternalMySqlDatabase

nessuno

connettori di database dbmgmt-external-mysql

Verbs Autorizzazioni API completamente coperte API parzialmente coperte

ispezionare

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDatabaseConnectors

nessuno

letto

ISPEZIONA +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_READ

GetExternalMySqlDatabaseConnector

nessuno

utilizzare

LETTO +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

UpdateExternalMysqlDatabaseConnector

CheckExternalMySqlDatabaseConnectorConnectionStatus (ha bisogno anche di read dbmgmt-external-mysql-databases)

DisableExternalMySqlDatabaseManagement (ha bisogno anche di use dbmgmt-external-mysql-databases)

EnableExternalMySqlDatabaseManagement (ha bisogno anche di use dbmgmt-external-mysql-databases)

gestisci

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_DELETE

nessuno

CreateExternalMySqlDatabaseConnector (ha bisogno anche di use dbmgmt-external-mysql-databases)

DeleteExternalMySqlDatabaseConnector (ha bisogno anche di use dbmgmt-external-mysql-databases)

Autorizzazioni necessarie per ogni operazione API

Nella tabella seguente sono elencate le operazioni API in ordine alfabetico.

Nota

Se si utilizzano le credenziali denominate per eseguire un'operazione API relativa a diagnostica e gestione per i database Oracle e i sistemi di database esterni, potrebbe essere necessaria l'autorizzazione DBMGMT_NAMED_CREDENTIAL_READ oltre alle autorizzazioni elencate per l'operazione API.

Per informazioni sulle autorizzazioni, vedere Autorizzazioni.

Operazione API Autorizzazioni necessarie per utilizzare l'operazione

AbortPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE o DBMGMT_DBLM_PATCH_OPERATION_UPDATE

AddManagedDatabaseToManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_ADD_DATABASE e DBMGMT_MANAGED_DB_UPDATE

AddmTasks

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ChangeDatabaseParameters

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeDatafiles

DBMGMT_MANAGED_DB_READ e 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 o DBMGMT_DBLM_PATCH_OPERATION_MOVE

ChangePlanRetention

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSpaceBudget

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSqlPlanBaselinesAttributes

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

CheckExternalDbSystemConnectorConnectionStatus

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalMySqlDatabaseConnectorConnectionStatus

DBMGMT_EXTERNAL_MYSQL_DB_READ e DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

CheckPatchConflict

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CloneSqlTuningTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

CoalesceTablespace

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

CompleteSpaTask

DBMGMT_SPA_TASK_COMPLETE

ConfigureAutomaticCaptureFilters

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ConfigureAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

CreateDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_CREATE

CreateExternalDbSystem

DBMGMT_EXTERNAL_DBSYSTEM_CREATE e 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 e DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

CreateJob

Le autorizzazioni richieste dipendono dal tipo SQL per i job SQL e dal tipo di risorsa.

  • Query: insieme all'autorizzazione DBMGMT_JOB_CREATE, è richiesta la seguente autorizzazione CONTENT_READ:
    • Per un database gestito: DBMGMT_MANAGED_DB_CONTENT_READ
    • Per un gruppo di database: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ
  • DDL/DML/PLSQL: oltre all'autorizzazione DBMGMT_JOB_CREATE, sono necessarie le seguenti autorizzazioni CONTENT_READ e CONTENT_WRITE:
    • Per un database gestito: DBMGMT_MANAGED_DB_CONTENT_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE
    • Per un gruppo di database: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ e DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

CreateManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_CREATE

CreateNamedCredential

DBMGMT_NAMED_CREDENTIAL_CREATE, DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

CreateSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CreateSoftwareImageVersion

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

CreateSqlTuningSet

DBMGMT_MANAGED_DB_READ e 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 e 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 e 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 o 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 e DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ e 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 e DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

DisableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DiscoverExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_CREATE

DropSqlPlanBaselines

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlsInSqlTuningSet

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningSet

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ e 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 e DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

EnableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

FetchSqlTuningSet

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GenerateAwrSnapshot

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

GetAwrDbReport

DBMGMT_MANAGED_DB_READ

GetAwrDbSqlReport

DBMGMT_MANAGED_DB_READ

GetBinaryLogInformation

DBMGMT_MANAGED_MYSQL_DB_READ e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetClusterCacheMetric

DBMGMT_MANAGED_DB_READ

GetDatabaseFleetBackupMetrics

  • Per una flotta di database gestiti ad alta disponibilità in un compartimento specifico: DBMGMT_MANAGED_DB_READ

  • Per una flotta di database gestiti ad alta disponibilità in un gruppo di database specifico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetDataguardMetrics

  • Per una flotta di database gestiti ad alta disponibilità in un compartimento specifico: DBMGMT_MANAGED_DB_READ

  • Per una flotta di database gestiti ad alta disponibilità in un gruppo di database specifico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHaOverviewMetrics

  • Per una flotta di database gestiti ad alta disponibilità in un compartimento specifico: DBMGMT_MANAGED_DB_READ

  • Per una flotta di database gestiti ad alta disponibilità in un gruppo di database specifico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHealthMetrics

  • Per una flotta di database gestiti in un compartimento specifico: DBMGMT_MANAGED_DB_READ

  • Per una flotta di database gestiti in un gruppo di database specifico: DBMGMT_MANAGED_DB_READ e 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 e DBMGMT_MANAGED_DB_CONTENT_READ

GetExternalAsm

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalAsmConfiguration

DBMGMT_EXTERNAL_DBSYSTEM_READ e 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 e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetHeatWaveFleetMetric

DBMGMT_MANAGED_MYSQL_DB_READ

GetIormPlan

DBMGMT_EXTERNAL_EXADATA_READ e 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 e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ

GetOpenAlertHistory

DBMGMT_EXTERNAL_EXADATA_READ e DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetOptimizerStatisticsAdvisorExecution

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsAdvisorExecutionScript

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsCollectionOperation

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetPatchInfoStore

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchManagement

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTask

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTaskStep

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o 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 o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o DBMGMT_DBLM_PATCH_OPERATION_READ

GetSqlExecutionPlan

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlPlanBaseline

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlPlanBaselineConfiguration

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlTuningAdvisorTaskSummaryReport

DBMGMT_MANAGED_DB_READ e 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 e DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetUser

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

GetVulnerability

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerabilityScan

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetWorkRequest

DBMGMT_WORK_REQUEST_READ

GetWorkRequest (per il rilevamento delle vulnerabilità)

DBMGMT_DBLM_WORK_REQUEST_READ

ImplementOptimizerStatisticsAdvisorRecommendations

DBMGMT_MANAGED_DB_READ, DBMGMT_MANAGED_DB_CONTENT_READ, DBMGMT_MANAGED_DB_CONTENT_WRITE e 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 e DBMGMT_MANAGED_DB_CONTENT_READ

ListAttentionLogs

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListAwrDbs

DBMGMT_MANAGED_DB_READ

ListAwrDbSnapshots

DBMGMT_MANAGED_DB_READ

ListConsumerGroupPrivileges

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListCreateLikeParameters

DBMGMT_SPA_TASK_TRIAL_CREATE

ListCursorCacheStatements

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListDataAccessContainers

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabaseParameters

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabases

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

ListDbManagementPrivateEndpoints

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListExternalAsmDiskGroups

DBMGMT_EXTERNAL_DBSYSTEM_READ e DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

ListExternalAsmInstances

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsms

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmUsers

DBMGMT_EXTERNAL_DBSYSTEM_READ e 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 e DBMGMT_MANAGED_DB_CONTENT_READ

ListExternalMySqlDatabases

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListHighAvailabilityMembers

DBMGMT_MANAGED_MYSQL_DB_READ e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListInboundReplications

DBMGMT_MANAGED_MYSQL_DB_READ e 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 e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListManagedMySqlDatabases

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabaseSqlData

DBMGMT_MANAGED_MYSQL_DB_READ e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListMySqlDatabaseConnectors

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDigestErrors

DBMGMT_MANAGED_MYSQL_DB_READ e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListNamedCredentials

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNotifications

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListObjectPrivileges

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsAdvisorExecutions

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionAggregations

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionOperations

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListOutboundReplications

DBMGMT_MANAGED_MYSQL_DB_READ e DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListPatchOperations

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTasks

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTaskSteps

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPreferredCredentials

DBMGMT_MANAGED_DB_READ

ListProxiedForUsers

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListProxyUsers

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListRoles

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSoftwareImages

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListSpmJobs

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlPlanBaselines

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskFindings

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskRecommendations

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTasks

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningSets

DBMGMT_MANAGED_DB_READ e 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 e DBMGMT_MANAGED_DB_CONTENT_READ

ListTablespaces

DBMGMT_MANAGED_DB_READ

ListTableStatistics

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ListUsers

DBMGMT_MANAGED_DB_READ e 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 (per il rilevamento delle vulnerabilità)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestLogs

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs (per il rilevamento delle vulnerabilità)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequests

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests (per il rilevamento delle vulnerabilità)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

LoadSqlPlanBaselinesFromAwr

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlPlanBaselinesFromCursorCache

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlTuningSet

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ModifySnapshotSettings

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

PatchExternalDbSystemDiscovery

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchResources

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE o DBMGMT_DBLM_PATCH_OPERATION_CREATE

PublishSqlResult

DBMGMT_SPA_TASK_PUBLISH_SQL_RESULT

QuickValidations

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE o DBMGMT_DBLM_PATCH_OPERATION_CREATE

RemoveManagedDatabaseFromManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_REMOVE_DATABASE e DBMGMT_MANAGED_DB_UPDATE

ResetDatabaseParameters

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ResumeSpaTask

DBMGMT_SPA_TASK_RESUME

RetryPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE o DBMGMT_DBLM_PATCH_OPERATION_UPDATE

RunHistoricAddm

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

SaveSqlTuningSetAs

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

ShrinkTablespace

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

StartSqlTuningTask

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE

Subscribe

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o 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 e DBMGMT_MANAGED_DB_CONTENT_READ

SummarizeSqlPlanBaselinesByLastExecution

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

TestNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ, DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

TestPreferredCredential

DBMGMT_MANAGED_DB_READ

Unsubscribe

DBMGMT_DBLM_PATCH_MANAGEMENT_READ o 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 e DBMGMT_MANAGED_DB_CONTENT_READ

UpdatePatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE o 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 e DBMGMT_MANAGED_DB_CONTENT_WRITE

ValidateBasicFilter

DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_CONTENT_READ

ValidateMosCredentials

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE