Detalles de políticas para Database Management

En los temas de esta sección se proporcionan detalles para escribir políticas de Oracle Cloud Infrastructure Identity and Access Management (IAM) a fin de controlar el acceso al servicio Database Management.

A continuación, se muestra información detallada y ejemplos de las políticas necesarias para trabajar con Database Management:

Tipos de recursos

Tipos de recursos de Oracle Database, sistema de base de datos externa e infraestructura de Exadata

Tipos de recursos agregados

dbmgmt-family

dbmgmt-dblm-family

Nota

El tipo de recurso agregado dbmgmt-family incluye todos los tipos de recursos individuales de Database Management y el tipo de recurso agregado dbmgmt-dblm-family, que a su vez incluye los siguientes tipos de recursos individuales:
  • dbmgmt-dblm-vulnerability
  • dbmgmt-dblm-workrequest
  • dbmgmt-dblm-patch-mgmt
  • dbmgmt-dblm-patch-operations

Tipos de recursos individuales

  • 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

Tipos de recursos del sistema de base de datos HeatWave y externo MySQL

Tipo de recurso agregado

dbmgmt-mysql-family

Tipo de recurso individual

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

Comentarios

Una política que utiliza <verb> dbmgmt-family equivale a escribir una política con una sentencia <verb> <individual resource-type> independiente para cada uno de los tipos de recursos individuales de la familia.

Consulte en las tablas Details for Verb + Resource-Type Combinations los detalles de las operaciones de API que cubre cada verbo para cada tipo de recurso individual.

Variables soportadas

Solo están soportadas las variables generales. Para obtener información, consulte Variables generales para todas las solicitudes.

Detalles de las combinaciones de verbo + tipo de recurso

En las siguientes tablas, se muestran los permisos y las operaciones de API que cubre cada verbo. El nivel de acceso es acumulativo a medida que pasa de inspect > read > use > manage. Un signo más (+) en una celda de la tabla indica un acceso incremental en comparación con la celda situada directamente encima, mientras que "sin extra" indica que no hay un acceso incremental.

dbmgmt-trabajos

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_JOB_INSPECT

ListJobs

ninguno

lectura

INSPECCIONAR +

DBMGMT_JOB_READ

GetJob

ListJobRuns

GetJobRun

ListJobExecutions

GetJobExecution

SummarizeJobExecutionsStatuses

ninguno

Usar

LEER +

sin extra

ninguno

ninguno

gestionar

USO +

DBMGMT_JOB_CREATE

DBMGMT_JOB_DELETE

DBMGMT_JOB_MOVE

DBMGMT_JOB_UPDATE

ChangeJobCompartment

DeleteJob

UpdateJob

CreateJob (también necesita use dbmgmt-managed-database-groups o use dbmgmt-managed-databases)

ImplementOptimizerStatisticsAdvisorRecommendations (también necesita use dbmgmt-managed-databases)

grupos de bases de datos gestionadas por dbmgmt

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_MANAGED_DB_GROUP_INSPECT

ListManagedDatabaseGroups

Ninguno

lectura

INSPECCIONAR +

DBMGMT_MANAGED_DB_GROUP_READ

GetManagedDatabaseGroup

GetDatabaseFleetBackupMetrics (también necesita read dbmgmt-managed-databases)

GetDatabaseFleetDataguardMetrics (también necesita read dbmgmt-managed-databases)

GetDatabaseFleetHaOverviewMetrics (también necesita read dbmgmt-managed-databases)

GetDatabaseFleetHealthMetrics (también necesita read dbmgmt-managed-databases)

Usar

LEER +

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

DBMGMT_MANAGED_DB_GROUP_UPDATE

UpdateManagedDatabaseGroup

CreateJob (también necesita manage dbmgmt-jobs)

gestionar

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 (también necesita use dbmgmt-managed-databases)

RemoveManagedDatabaseFromManagedDatabaseGroup (también necesita use dbmgmt-managed-databases)

bases de datos gestionadas por dbmgmt

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_MANAGED_DB_INSPECT

ListManagedDatabases

ninguno

lectura

INSPECCIONAR +

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

ninguno

Usar

LEER +

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 (también necesita manage dbmgmt-managed-database-groups)

CreateJob (también necesita manage dbmgmt-jobs)

CreateNamedCredential (también necesita manage dbmgmt-named-credentials)

ImplementOptimizerStatisticsAdvisorRecommendations (también necesita manage dbmgmt-jobs)

ListExternalListenerServices (también necesita read dbmgmt-external-dbsystems)

RemoveManagedDatabaseFromManagedDatabaseGroup (también necesita manage dbmgmt-managed-database-groups)

TestNamedCredential (también necesita read dbmgmt-named-credentials)

UpdateNamedCredential (también necesita use dbmgmt-named-credentials)

gestionar

USE +

sin extra

Ninguno

Ninguno

dbmgmt-private-endpoints

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListDbManagementPrivateEndpoints

Ninguno

lectura

INSPECCIONAR +

DBMGMT_PRIVATE_ENDPOINT_READ

GetDbManagementPrivateEndpoint

Ninguno

Usar

LEER +

DBMGMT_PRIVATE_ENDPOINT_UPDATE

UpdateDbManagementPrivateEndpoint

ninguno

gestionar

USE +

DBMGMT_PRIVATE_ENDPOINT_CREATE

DBMGMT_PRIVATE_ENDPOINT_DELETE

DBMGMT_PRIVATE_ENDPOINT_MOVE

CreateDbManagementPrivateEndpoint

DeleteDbManagementPrivateEndpoint

ChangeDbManagementPrivateEndpointCompartment

ninguno

dbmgmt-work-requests

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests

ninguno

lectura

INSPECCIONAR +

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs

ListWorkRequestErrors

GetWorkRequest

ninguno

Usar

LEER +

sin extra

ninguno

ninguno

gestionar

LEER +

USO +

sin extra

ninguno

ninguno

dbmgmt-external-dbsystem-discoveres (Descubrimientos del sistema de base de datos externo)

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_INSPECT

ListExternalDbSystemDiscoveries

ninguno

lectura

INSPECCIONAR +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

GetExternalDbSystemDiscovery

CreateExternalDbSystem (también necesita manage dbmgmt-external-dbsystems)

Usar

LEER +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchExternalDbSystemDiscovery

UpdateExternalDbSystemDiscovery

ninguno

gestionar

USO +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_DELETE

CreateExternalDbSystemDiscovery

DeleteExternalDbSystemDiscovery

ninguno

dbmgmt-external-dbsystems (sistemas de base de datos externos)

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmInstances

ListExternalAsms

ListExternalClusterInstances

ListExternalClusters

ListExternalDatabases

ListExternalDbHomes

ListExternalDbNodes

ListExternalDbSystemConnectors

ListExternalDbSystems

ListExternalListeners

ninguno

lectura

INSPECCIONAR +

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalDbSystemConnectorConnectionStatus

GetExternalAsm

GetExternalAsmInstance

GetExternalAsmMetrics

GetExternalCluster

GetExternalClusterInstance

GetExternalClusterMetrics

GetExternalDbHome

GetExternalDbNode

GetExternalDbNodeMetrics

GetExternalDbSystem

GetExternalDbSystemAvailabilityMetrics

GetExternalDbSystemConnector

GetExternalListener

GetExternalListenerMetrics

ListExternalListenerServices (también necesita use dbmgmt-managed-databases)

Usar

LEER +

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

ninguno

gestionar

USO +

DBMGMT_EXTERNAL_DBSYSTEM_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DBMGMT_EXTERNAL_DBSYSTEM_MOVE

ChangeExternalDbSystemCompartment

CreateExternalDbSystemConnector

DeleteExternalDbSystem

DeleteExternalDbSystemConnector

CreateExternalDbSystem (también necesita read dbmgmt-external-dbsystem-discoveries)

dbmgmt-externa-exadata

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataInfrastructures

ListExternalExadataStorageServerConnectors

ListExternalExadataStorageServers

ninguno

lectura

INSPECCIONAR +

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalExadataStorageServerConnector

GetExternalExadataInfrastructure

GetExternalExadataStorageGrid

GetExternalExadataStorageServer

GetExternalExadataStorageServerConnector

ninguno

Usar

LEER +

DBMGMT_EXTERNAL_EXADATA_UPDATE

DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

DBMGMT_EXTERNAL_EXADATA_CONTENT_WRITE

DisableExternalExadataInfrastructureManagement

EnableExternalExadataInfrastructureManagement

GetIormPlan

GetOpenAlertHistory

GetTopSqlCpuActivity

UpdateExternalExadataInfrastructure

UpdateExternalExadataStorageServerConnector

ninguno

gestionar

USE +

DBMGMT_EXTERNAL_EXADATA_CREATE

DBMGMT_EXTERNAL_EXADATA_DELETE

DBMGMT_EXTERNAL_EXADATA_MOVE

ChangeExternalExadataInfrastructureCompartment

CreateExternalExadataInfrastructure

CreateExternalExadataStorageServerConnector

DeleteExternalExadataInfrastructure

DeleteExternalExadataStorageServerConnector

DiscoverExternalExadataInfrastructure

ninguno

dbmgmt-named-credentials (credenciales con nombre de dbmgmt)

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNamedCredentials

ninguno

lectura

INSPECCIONAR +

DBMGMT_NAMED_CREDENTIAL_READ

GetNamedCredential

TestNamedCredential (también necesita use dbmgmt-managed-databases)

Usar

LEER +

DBMGMT_NAMED_CREDENTIAL_UPDATE

ninguno

UpdateNamedCredential (también necesita use dbmgmt-managed-databases)

gestionar

USE +

DBMGMT_NAMED_CREDENTIAL_CREATE

DBMGMT_NAMED_CREDENTIAL_DELETE

DBMGMT_NAMED_CREDENTIAL_MOVE

ChangeNamedCredentialCompartment

DeleteNamedCredential

CreateNamedCredential (también necesita use dbmgmt-managed-databases)

dbmgmt-dblm-vulnerabilidad

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspeccionar

DBMGMT_DBLM_VUL_ASSESSMENT_INSPECT

ListVulnerabilityScans

ninguna

lectura

INSPECCIONAR +

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerability

GetVulnerabilityScan

ListAggregatedVulnerabilityData

ListNotifications

ListVulnerabilities

ListVulnerabilityResources

ninguna

Usar

LEER +

sin extra

ninguna

ninguna

gestionar

USO +

DBMGMT_DBLM_INGEST

DBMGMT_DBLM_VUL_ASSESSMENT_CREATE

DBMGMT_DBLM_VUL_ASSESSMENT_DELETE

DBMGMT_DBLM_VUL_ASSESSMENT_UPDATE

CreateVulnerabilityScan

Ingest

IngestError

IngestWorkDetails

ninguna

dbmgmt-dblm-workrequest

Verbos Permisos API totalmente cubiertas API Parcialmente Cubiertas

inspeccionar

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestErrors

ListWorkRequestLogs

ListWorkRequests

ninguna

leído

INSPECCIONAR +

DBMGMT_DBLM_WORK_REQUEST_READ

GetWorkRequest

ninguna

usar

LEÍDO +

sin extra

ninguna

ninguna

gestionar

USE +

sin extra

ninguna

ninguna

dbmgmt-dblm-patch-mgmt

Verbos Permisos API totalmente cubiertas API Parcialmente Cubiertas

inspeccionar

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

GetReleaseVersionDetail

ListDatabases

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

ninguna

leído

INSPECCIONAR +

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchInfoStore

GetPatchManagement

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

ninguna

usar

LEÍDO +

sin extra

ninguna

ninguna

gestionar

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

ninguna

dbmgmt-dblm-patch-operations

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetReleaseVersionDetail

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

ninguna

leído

INSPECT +

DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchInfoStore

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

ninguna

usar

READ +

sin extra

ninguna

ninguna

gestionar

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

ninguna

dbmgmt-sqlwatch-fleet

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_SPA_FLEET_INSPECT

ninguna

ninguna

leído

INSPECT +

DBMGMT_SPA_FLEET_READ

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchFleet

GetSqlWatchFleetComparison

ListSqlWatchFleetComparisons

ninguna

usar

READ +

DBMGMT_SPA_FLEET_DB_COMPARISON_UPDATE

UpdateSqlWatchFleetComparison

ninguna

gestionar

USE +

DBMGMT_SPA_FLEET_DB_COMPARISON_CREATE

DBMGMT_SPA_FLEET_DB_COMPARISON_DELETE

CreateSqlWatchFleetComparison

DeleteSqlWatchFleetComparison

ninguna

dbmgmt-sqlwatch-spa

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_SPA_TASK_INSPECT

ListSqlWatchTasks

ninguna

leído

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

ninguna

usar

READ +

DBMGMT_SPA_TASK_UPDATE

DBMGMT_SPA_TASK_INTERRUPT

DBMGMT_SPA_TASK_COMPLETE

DBMGMT_SPA_TASK_RESUME

CompleteSpaTask

InterruptSpaTask

ResumeSpaTask

UpdateSqlWatchTask

UpdateSqlWatchTaskComparison

UpdateSqlWatchTaskTrial

ninguna

gestionar

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

ninguna

bases de datos dbmgmt-managed-mysql

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabases

ninguna

leído

INSPECT +

DBMGMT_MANAGED_MYSQL_DB_READ

GetHeatWaveFleetMetric

GetManagedMySqlDatabase

GetMySqlFleetMetric

SummarizeManagedMySqlDatabaseAvailabilityMetrics

ninguna

usar

READ +

DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

DBMGMT_MANAGED_MYSQL_DB_UPDATE

ChangeMysqlDatabaseManagementType

GetBinaryLogInformation

GetGeneralReplicationInformation

GetMySqlQueryDetails

ListHighAvailabilityMembers

ListInboundReplications

ListManagedMySqlDatabaseConfigurationData

ListManagedMySqlDatabaseSqlData

ListMySqlDigestErrors

ListOutboundReplications

ninguna

gestionar

USE +

sin extra

ninguna

ninguna

dbmgmt-external-mysql-databases

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListExternalMySqlDatabases

ninguna

leído

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_READ

GetExternalMySqlDatabase

CheckExternalMySqlDatabaseConnectorConnectionStatus (también necesita use dbmgmt-external-mysql-database-connectors)

usar

READ +

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE

UpdateExternalMysqlDatabase

CreateExternalMySqlDatabaseConnector (también necesita manage dbmgmt-external-mysql-database-connectors)

DeleteExternalMySqlDatabaseConnector (también necesita manage dbmgmt-external-mysql-database-connectors)

DisableExternalMySqlDatabaseManagement (también necesita use dbmgmt-external-mysql-database-connectors)

EnableExternalMySqlDatabaseManagement (también necesita use dbmgmt-external-mysql-database-connectors)

gestionar

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_DELETE

CreateExternalMySqlDatabase

DeleteExternalMySqlDatabase

ninguna

dbmgmt-external-mysql-database-connectors

Verbos Permisos API totalmente cubiertas API parcialmente cubiertas

inspect

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDatabaseConnectors

ninguna

leído

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_READ

GetExternalMySqlDatabaseConnector

ninguna

usar

READ +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

UpdateExternalMysqlDatabaseConnector

CheckExternalMySqlDatabaseConnectorConnectionStatus (también necesita read dbmgmt-external-mysql-databases)

DisableExternalMySqlDatabaseManagement (también necesita use dbmgmt-external-mysql-databases)

EnableExternalMySqlDatabaseManagement (también necesita use dbmgmt-external-mysql-databases)

gestionar

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_DELETE

ninguna

CreateExternalMySqlDatabaseConnector (también necesita use dbmgmt-external-mysql-databases)

DeleteExternalMySqlDatabaseConnector (también necesita use dbmgmt-external-mysql-databases)

Permisos necesarios para cada operación de API

En la siguiente tabla, se muestran las operaciones de API en orden alfabético.

Nota

Si utiliza credenciales con nombre para realizar una operación de API perteneciente a Diagnostics & Management for Oracle Databases and External Database Systems, puede que se necesite el permiso DBMGMT_NAMED_CREDENTIAL_READ además de los permisos mostrados para la operación de API.

Para obtener información sobre los permisos, consulte Permisos.

Operación de API Permisos necesarios para utilizar la operación

AbortPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE o DBMGMT_DBLM_PATCH_OPERATION_UPDATE

AddManagedDatabaseToManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_ADD_DATABASE y DBMGMT_MANAGED_DB_UPDATE

AddmTasks

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ChangeDatabaseParameters

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeDatafiles

DBMGMT_MANAGED_DB_READ y 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 y DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSpaceBudget

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

ChangeSqlPlanBaselinesAttributes

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

CheckExternalDbSystemConnectorConnectionStatus

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalExadataStorageServerConnector

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalMySqlDatabaseConnectorConnectionStatus

DBMGMT_EXTERNAL_MYSQL_DB_READ y DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

CheckPatchConflict

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CloneSqlTuningTask

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

CoalesceTablespace

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

CompleteSpaTask

DBMGMT_SPA_TASK_COMPLETE

ConfigureAutomaticCaptureFilters

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

ConfigureAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

CreateDbManagementPrivateEndpoint

DBMGMT_PRIVATE_ENDPOINT_CREATE

CreateExternalDbSystem

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

CreateJob

Los permisos necesarios dependen del tipo de SQL para los trabajos de SQL y del tipo de recurso.

  • Consulta: junto con el permiso DBMGMT_JOB_CREATE, se necesita el siguiente permiso CONTENT_READ:
    • Para una base de datos gestionada: DBMGMT_MANAGED_DB_CONTENT_READ
    • Para un grupo de bases de datos: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ
  • DDL/DML/PLSQL: junto con el permiso DBMGMT_JOB_CREATE, se necesitan los siguientes permisos CONTENT_READ y CONTENT_WRITE:
    • Para una base de datos gestionada: DBMGMT_MANAGED_DB_CONTENT_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE
    • Para un grupo de bases de datos: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ y DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

CreateManagedDatabaseGroup

DBMGMT_MANAGED_DB_GROUP_CREATE

CreateNamedCredential

DBMGMT_NAMED_CREDENTIAL_CREATE, DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

CreateSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE

CreateSoftwareImageVersion

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE

CreateSqlTuningSet

DBMGMT_MANAGED_DB_READ y 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 y 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 y 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 y DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableAutomaticSpmEvolveAdvisorTask

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

DisableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DisableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DiscoverExternalExadataInfrastructure

DBMGMT_EXTERNAL_EXADATA_CREATE

DropSqlPlanBaselines

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlsInSqlTuningSet

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningSet

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

DropSqlTuningTask

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticInitialPlanCapture

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableAutomaticSpmEvolveAdvisorTask

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

EnableHighFrequencyAutomaticSpmEvolveAdvisorTask

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

EnableSqlPlanBaselinesUsage

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

FetchSqlTuningSet

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GenerateAwrSnapshot

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

GetAwrDbReport

DBMGMT_MANAGED_DB_READ

GetAwrDbSqlReport

DBMGMT_MANAGED_DB_READ

GetBinaryLogInformation

DBMGMT_MANAGED_MYSQL_DB_READ y DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

GetClusterCacheMetric

DBMGMT_MANAGED_DB_READ

GetDatabaseFleetBackupMetrics

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un grupo de bases de datos específico: DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetDataguardMetrics

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un grupo de bases de datos específico: DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHaOverviewMetrics

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para un conjunto de bases de datos gestionadas de alta disponibilidad en un grupo de bases de datos específico: DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHealthMetrics

  • Para un conjunto de bases de datos gestionadas en un compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para un conjunto de bases de datos gestionadas en un grupo de bases de datos específico: DBMGMT_MANAGED_DB_READ y 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 y DBMGMT_MANAGED_DB_CONTENT_READ

GetExternalAsm

DBMGMT_EXTERNAL_DBSYSTEM_READ

GetExternalAsmConfiguration

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

GetHeatWaveFleetMetric

DBMGMT_MANAGED_MYSQL_DB_READ

GetIormPlan

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

GetNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ

GetOpenAlertHistory

DBMGMT_EXTERNAL_EXADATA_READ y DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

GetOptimizerStatisticsAdvisorExecution

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsAdvisorExecutionScript

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GetOptimizerStatisticsCollectionOperation

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

GetSqlPlanBaseline

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlPlanBaselineConfiguration

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GetSqlTuningAdvisorTaskSummaryReport

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

GetUser

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

GetVulnerability

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerabilityScan

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetWorkRequest

DBMGMT_WORK_REQUEST_READ

GetWorkRequest (para detección de vulnerabilidades)

DBMGMT_DBLM_WORK_REQUEST_READ

ImplementOptimizerStatisticsAdvisorRecommendations

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

ListAttentionLogs

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListAwrDbs

DBMGMT_MANAGED_DB_READ

ListAwrDbSnapshots

DBMGMT_MANAGED_DB_READ

ListConsumerGroupPrivileges

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListCreateLikeParameters

DBMGMT_SPA_TASK_TRIAL_CREATE

ListCursorCacheStatements

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListDataAccessContainers

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabaseParameters

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListDatabases

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

ListDbManagementPrivateEndpoints

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListExternalAsmDiskGroups

DBMGMT_EXTERNAL_DBSYSTEM_READ y DBMGMT_EXTERNAL_DBSYSTEM_CONTENT_READ

ListExternalAsmInstances

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsms

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmUsers

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

ListExternalMySqlDatabases

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListHighAvailabilityMembers

DBMGMT_MANAGED_MYSQL_DB_READ y DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListInboundReplications

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

ListManagedMySqlDatabases

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabaseSqlData

DBMGMT_MANAGED_MYSQL_DB_READ y DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListMySqlDatabaseConnectors

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDigestErrors

DBMGMT_MANAGED_MYSQL_DB_READ y DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

ListNamedCredentials

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNotifications

DBMGMT_DBLM_VUL_ASSESSMENT_READ

ListObjectPrivileges

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsAdvisorExecutions

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionAggregations

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListOptimizerStatisticsCollectionOperations

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListOutboundReplications

DBMGMT_MANAGED_MYSQL_DB_READ y 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 y DBMGMT_MANAGED_DB_CONTENT_READ

ListProxyUsers

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListRoles

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSoftwareImages

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT o DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListSpmJobs

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlPlanBaselines

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskFindings

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTaskRecommendations

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningAdvisorTasks

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListSqlTuningSets

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

ListTablespaces

DBMGMT_MANAGED_DB_READ

ListTableStatistics

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ListUsers

DBMGMT_MANAGED_DB_READ y 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 (para detección de vulnerabilidades)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestLogs

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs (para detección de vulnerabilidades)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequests

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests (para detección de vulnerabilidades)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

LoadSqlPlanBaselinesFromAwr

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlPlanBaselinesFromCursorCache

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

LoadSqlTuningSet

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

ModifySnapshotSettings

DBMGMT_MANAGED_DB_READ y 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 y DBMGMT_MANAGED_DB_UPDATE

ResetDatabaseParameters

DBMGMT_MANAGED_DB_READ y 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 y DBMGMT_MANAGED_DB_CONTENT_WRITE

SaveSqlTuningSetAs

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

ShrinkTablespace

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_WRITE

StartSqlTuningTask

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

SummarizeSqlPlanBaselinesByLastExecution

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

TestNamedCredential

DBMGMT_NAMED_CREDENTIAL_READ, DBMGMT_MANAGED_DB_READ y 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 y 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 y DBMGMT_MANAGED_DB_CONTENT_WRITE

ValidateBasicFilter

DBMGMT_MANAGED_DB_READ y DBMGMT_MANAGED_DB_CONTENT_READ

ValidateMosCredentials

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE