Detalhes da Política do Serviço Database Management

Os tópicos desta seção fornecem detalhes para criar políticas do Oracle Cloud Infrastructure Identity and Access Management (IAM) para controlar o acesso ao serviço Database Management.

Veja informações detalhadas e exemplos das políticas necessárias para trabalhar com o Database Management:

Tipos de Recursos

Oracle Database, Sistema de Banco de Dados Externo e Tipos de Recursos do Exadata Infrastructure

Tipos de Recursos Agregados

dbmgmt-family

dbmgmt-dblm-family

Observação

O tipo de recurso agregado dbmgmt-family inclui todos os tipos de recursos individuais do Database Management e o tipo de recurso agregado dbmgmt-dblm-family, que por sua vez inclui os seguintes tipos de recursos individuais:
  • dbmgmt-dblm-vulnerability
  • dbmgmt-dblm-workrequest
  • dbmgmt-dblm-patch-mgmt
  • dbmgmt-dblm-patch-operations

Resource-types Individuais

  • 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 do Sistema de BD HeatWave e 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

Comentários

Uma política que usa <verb> dbmgmt-family é equivalente a gravar uma instrução <verb> <individual resource-type> separada para cada tipo de recurso individual na família.

Consulte as tabelas em Detalhes para Combinações de Verbo + Resource-Type para obter um detalhamento das operações da API abrangidas por cada verbo, para cada resource-type individual.

variáveis suportadas

Só há suporte para variáveis gerais. Para obter informações, consulte variáveis gerais para todas as solicitações.

Detalhes das Combinações de Verbo + Tipo de Recurso

As tabelas a seguir mostram as permissões e operações de API abrangidas por cada verbo. O nível de acesso é cumulativo conforme você vai de inspect > read > use > manage. Um sinal de mais (+) em uma célula da tabela indica acesso incremental em comparação com a célula diretamente acima, enquanto "nenhum extra" indica nenhum acesso incremental.

gerenciamento de banco de dados - cargos

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_JOB_INSPECT

ListJobs

nenhum

leitura

INSPECIONAR +

DBMGMT_JOB_READ

GetJob

ListJobRuns

GetJobRun

ListJobExecutions

GetJobExecution

SummarizeJobExecutionsStatuses

nenhum

use

LER +

nenhum extra

nenhum

nenhuma

gerenciar

USAR +

DBMGMT_JOB_CREATE

DBMGMT_JOB_DELETE

DBMGMT_JOB_MOVE

DBMGMT_JOB_UPDATE

ChangeJobCompartment

DeleteJob

UpdateJob

CreateJob (também precisa de use dbmgmt-managed-database-groups ou use dbmgmt-managed-databases)

ImplementOptimizerStatisticsAdvisorRecommendations (também precisa de use dbmgmt-managed-databases)

dbmgmt-managed-database-groups

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_MANAGED_DB_GROUP_INSPECT

ListManagedDatabaseGroups

nenhum

lido

INSPECIONAR +

DBMGMT_MANAGED_DB_GROUP_READ

GetManagedDatabaseGroup

GetDatabaseFleetBackupMetrics (também precisa de read dbmgmt-managed-databases)

GetDatabaseFleetDataguardMetrics (também precisa de read dbmgmt-managed-databases)

GetDatabaseFleetHaOverviewMetrics (também precisa de read dbmgmt-managed-databases)

GetDatabaseFleetHealthMetrics (também precisa de read dbmgmt-managed-databases)

use

LEITURA +

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ

DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_WRITE

DBMGMT_MANAGED_DB_GROUP_UPDATE

UpdateManagedDatabaseGroup

CreateJob (também precisa de manage dbmgmt-jobs)

gerenciar

USAR +

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 (também precisa de use dbmgmt-managed-databases)

RemoveManagedDatabaseFromManagedDatabaseGroup (também precisa de use dbmgmt-managed-databases)

dbmgmt-managed-databases

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Abrangidas

inspecionar

DBMGMT_MANAGED_DB_INSPECT

ListManagedDatabases

nenhum

leitura

INSPECIONAR +

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

nenhuma

use

LER +

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 (também precisa de manage dbmgmt-managed-database-groups)

CreateJob (também precisa de manage dbmgmt-jobs)

CreateNamedCredential (também precisa de manage dbmgmt-named-credentials)

ImplementOptimizerStatisticsAdvisorRecommendations (também precisa de manage dbmgmt-jobs)

ListExternalListenerServices (também precisa de read dbmgmt-external-dbsystems)

RemoveManagedDatabaseFromManagedDatabaseGroup (também precisa de manage dbmgmt-managed-database-groups)

TestNamedCredential (também precisa de read dbmgmt-named-credentials)

UpdateNamedCredential (também precisa de use dbmgmt-named-credentials)

gerenciar

USAR +

nenhum extra

nenhum

nenhum

dbmgmt-private-endpoints

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_PRIVATE_ENDPOINT_INSPECT

ListDbManagementPrivateEndpoints

nenhum

leitura

INSPECIONAR +

DBMGMT_PRIVATE_ENDPOINT_READ

GetDbManagementPrivateEndpoint

nenhum

use

LER +

DBMGMT_PRIVATE_ENDPOINT_UPDATE

UpdateDbManagementPrivateEndpoint

nenhum

gerenciar

USAR +

DBMGMT_PRIVATE_ENDPOINT_CREATE

DBMGMT_PRIVATE_ENDPOINT_DELETE

DBMGMT_PRIVATE_ENDPOINT_MOVE

CreateDbManagementPrivateEndpoint

DeleteDbManagementPrivateEndpoint

ChangeDbManagementPrivateEndpointCompartment

nenhum

dbmgmt-work-solicitações

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Abrangidas

inspecionar

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests

nenhum

leitura

INSPECIONAR +

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs

ListWorkRequestErrors

GetWorkRequest

nenhum

use

LER +

nenhum extra

nenhum

nenhum

gerenciar

LER +

USAR +

nenhum extra

nenhuma

nenhuma

dbmgmt-external-dbsystem-descobertas

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Abrangidas

inspecionar

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_INSPECT

ListExternalDbSystemDiscoveries

nenhum

leitura

INSPECIONAR +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_READ

GetExternalDbSystemDiscovery

CreateExternalDbSystem (também precisa de manage dbmgmt-external-dbsystems)

use

LER +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_UPDATE

PatchExternalDbSystemDiscovery

UpdateExternalDbSystemDiscovery

nenhum

gerenciar

USAR +

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DISCOVERY_DELETE

CreateExternalDbSystemDiscovery

DeleteExternalDbSystemDiscovery

nenhum

dbmgmt-external-dbsystems

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_EXTERNAL_DBSYSTEM_INSPECT

ListExternalAsmInstances

ListExternalAsms

ListExternalClusterInstances

ListExternalClusters

ListExternalDatabases

ListExternalDbHomes

ListExternalDbNodes

ListExternalDbSystemConnectors

ListExternalDbSystems

ListExternalListeners

nenhum

lido

INSPECIONAR +

DBMGMT_EXTERNAL_DBSYSTEM_READ

CheckExternalDbSystemConnectorConnectionStatus

GetExternalAsm

GetExternalAsmInstance

GetExternalAsmMetrics

GetExternalCluster

GetExternalClusterInstance

GetExternalClusterMetrics

GetExternalDbHome

GetExternalDbNode

GetExternalDbNodeMetrics

GetExternalDbSystem

GetExternalDbSystemAvailabilityMetrics

GetExternalDbSystemConnector

GetExternalListener

GetExternalListenerMetrics

ListExternalListenerServices (também precisa de use dbmgmt-managed-databases)

use

LEITURA +

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

nenhum

gerenciar

USAR +

DBMGMT_EXTERNAL_DBSYSTEM_CREATE

DBMGMT_EXTERNAL_DBSYSTEM_DELETE

DBMGMT_EXTERNAL_DBSYSTEM_MOVE

ChangeExternalDbSystemCompartment

CreateExternalDbSystemConnector

DeleteExternalDbSystem

DeleteExternalDbSystemConnector

CreateExternalDbSystem (também precisa de read dbmgmt-external-dbsystem-discoveries)

dbmgmt-external-exadata

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Abrangidas

inspecionar

DBMGMT_EXTERNAL_EXADATA_INSPECT

ListExternalExadataInfrastructures

ListExternalExadataStorageServerConnectors

ListExternalExadataStorageServers

nenhum

leitura

INSPECIONAR +

DBMGMT_EXTERNAL_EXADATA_READ

CheckExternalExadataStorageServerConnector

GetExternalExadataInfrastructure

GetExternalExadataStorageGrid

GetExternalExadataStorageServer

GetExternalExadataStorageServerConnector

nenhum

use

LER +

DBMGMT_EXTERNAL_EXADATA_UPDATE

DBMGMT_EXTERNAL_EXADATA_CONTENT_READ

DBMGMT_EXTERNAL_EXADATA_CONTENT_WRITE

DisableExternalExadataInfrastructureManagement

EnableExternalExadataInfrastructureManagement

GetIormPlan

GetOpenAlertHistory

GetTopSqlCpuActivity

UpdateExternalExadataInfrastructure

UpdateExternalExadataStorageServerConnector

nenhuma

gerenciar

USAR +

DBMGMT_EXTERNAL_EXADATA_CREATE

DBMGMT_EXTERNAL_EXADATA_DELETE

DBMGMT_EXTERNAL_EXADATA_MOVE

ChangeExternalExadataInfrastructureCompartment

CreateExternalExadataInfrastructure

CreateExternalExadataStorageServerConnector

DeleteExternalExadataInfrastructure

DeleteExternalExadataStorageServerConnector

DiscoverExternalExadataInfrastructure

nenhuma

dbmgmt-named-credentials

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_NAMED_CREDENTIAL_INSPECT

ListNamedCredentials

nenhuma

leitura

INSPECIONAR +

DBMGMT_NAMED_CREDENTIAL_READ

GetNamedCredential

TestNamedCredential (também precisa de use dbmgmt-managed-databases)

use

LER +

DBMGMT_NAMED_CREDENTIAL_UPDATE

nenhuma

UpdateNamedCredential (também precisa de use dbmgmt-managed-databases)

gerenciar

USAR +

DBMGMT_NAMED_CREDENTIAL_CREATE

DBMGMT_NAMED_CREDENTIAL_DELETE

DBMGMT_NAMED_CREDENTIAL_MOVE

ChangeNamedCredentialCompartment

DeleteNamedCredential

CreateNamedCredential (também precisa de use dbmgmt-managed-databases)

dbmgmt-dblm-vulnerabilidade

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_DBLM_VUL_ASSESSMENT_INSPECT

ListVulnerabilityScans

nenhum

lido

INSPECIONAR +

DBMGMT_DBLM_VUL_ASSESSMENT_READ

GetVulnerability

GetVulnerabilityScan

ListAggregatedVulnerabilityData

ListNotifications

ListVulnerabilities

ListVulnerabilityResources

nenhum

use

LEITURA +

nenhum extra

nenhum

nenhum

gerenciar

USAR +

DBMGMT_DBLM_INGEST

DBMGMT_DBLM_VUL_ASSESSMENT_CREATE

DBMGMT_DBLM_VUL_ASSESSMENT_DELETE

DBMGMT_DBLM_VUL_ASSESSMENT_UPDATE

CreateVulnerabilityScan

Ingest

IngestError

IngestWorkDetails

nenhum

dbmgmt-dblm-solicitação de trabalho

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestErrors

ListWorkRequestLogs

ListWorkRequests

nenhum

leitura

INSPECIONAR +

DBMGMT_DBLM_WORK_REQUEST_READ

GetWorkRequest

nenhum

use

LEITURA +

nenhum extra

nenhum

nenhum

gerenciar

USAR +

nenhum extra

nenhum

nenhum

dbmgmt-dblm-patch-mgmt

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT

GetReleaseVersionDetail

ListDatabases

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

nenhum

leitura

INSPECIONAR +

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchInfoStore

GetPatchManagement

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

nenhum

use

LEITURA +

nenhum extra

nenhum

nenhum

gerenciar

USAR +

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

nenhum

dbmgmt-dblm-patch-operações

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_DBLM_PATCH_OPERATION_INSPECT

GetReleaseVersionDetail

ListPatchOperations

ListPatchTasks

ListPatchTaskSteps

ListSoftwareImages

nenhum

leitura

INSPECT +

DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchInfoStore

GetPatchOperation

GetPatchTask

GetPatchTaskStep

GetSoftwareImage

Subscribe

Unsubscribe

nenhum

use

READ +

nenhum extra

nenhum

nenhum

gerenciar

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

nenhum

dbmgmt-sqlwatch-frota

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_SPA_FLEET_INSPECT

nenhum

nenhum

leitura

INSPECT +

DBMGMT_SPA_FLEET_READ

DBMGMT_SPA_FLEET_DB_READ

GetSqlWatchFleet

GetSqlWatchFleetComparison

ListSqlWatchFleetComparisons

nenhum

use

READ +

DBMGMT_SPA_FLEET_DB_COMPARISON_UPDATE

UpdateSqlWatchFleetComparison

nenhum

gerenciar

USE +

DBMGMT_SPA_FLEET_DB_COMPARISON_CREATE

DBMGMT_SPA_FLEET_DB_COMPARISON_DELETE

CreateSqlWatchFleetComparison

DeleteSqlWatchFleetComparison

nenhum

dbmgmt-sqlwatch-spa

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_SPA_TASK_INSPECT

ListSqlWatchTasks

nenhum

leitura

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

nenhum

use

READ +

DBMGMT_SPA_TASK_UPDATE

DBMGMT_SPA_TASK_INTERRUPT

DBMGMT_SPA_TASK_COMPLETE

DBMGMT_SPA_TASK_RESUME

CompleteSpaTask

InterruptSpaTask

ResumeSpaTask

UpdateSqlWatchTask

UpdateSqlWatchTaskComparison

UpdateSqlWatchTaskTrial

nenhum

gerenciar

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

nenhum

dbmgmt-managed-mysql-databases

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_MANAGED_MYSQL_DB_INSPECT

ListManagedMySqlDatabases

nenhum

leitura

INSPECT +

DBMGMT_MANAGED_MYSQL_DB_READ

GetHeatWaveFleetMetric

GetManagedMySqlDatabase

GetMySqlFleetMetric

SummarizeManagedMySqlDatabaseAvailabilityMetrics

nenhum

use

READ +

DBMGMT_MANAGED_MYSQL_DB_CONTENT_READ

DBMGMT_MANAGED_MYSQL_DB_UPDATE

ChangeMysqlDatabaseManagementType

GetBinaryLogInformation

GetGeneralReplicationInformation

GetMySqlQueryDetails

ListHighAvailabilityMembers

ListInboundReplications

ListManagedMySqlDatabaseConfigurationData

ListManagedMySqlDatabaseSqlData

ListMySqlDigestErrors

ListOutboundReplications

nenhum

gerenciar

USE +

nenhum extra

nenhum

nenhum

dbmgmt-external-mysql-bancos de dados

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_EXTERNAL_MYSQL_DB_INSPECT

ListExternalMySqlDatabases

nenhum

leitura

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_READ

GetExternalMySqlDatabase

CheckExternalMySqlDatabaseConnectorConnectionStatus (também precisa de use dbmgmt-external-mysql-database-connectors)

use

READ +

DBMGMT_EXTERNAL_MYSQL_DB_UPDATE

UpdateExternalMysqlDatabase

CreateExternalMySqlDatabaseConnector (também precisa de manage dbmgmt-external-mysql-database-connectors)

DeleteExternalMySqlDatabaseConnector (também precisa de manage dbmgmt-external-mysql-database-connectors)

DisableExternalMySqlDatabaseManagement (também precisa de use dbmgmt-external-mysql-database-connectors)

EnableExternalMySqlDatabaseManagement (também precisa de use dbmgmt-external-mysql-database-connectors)

gerenciar

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_DELETE

CreateExternalMySqlDatabase

DeleteExternalMySqlDatabase

nenhum

dbmgmt-external-mysql-database-connecters

Verbos Permissões APIs Totalmente Incluídas APIs Parcialmente Incluídas

inspecionar

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_INSPECT

ListMySqlDatabaseConnectors

nenhum

leitura

INSPECT +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_READ

GetExternalMySqlDatabaseConnector

nenhum

use

READ +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_UPDATE

UpdateExternalMysqlDatabaseConnector

CheckExternalMySqlDatabaseConnectorConnectionStatus (também precisa de read dbmgmt-external-mysql-databases)

DisableExternalMySqlDatabaseManagement (também precisa de use dbmgmt-external-mysql-databases)

EnableExternalMySqlDatabaseManagement (também precisa de use dbmgmt-external-mysql-databases)

gerenciar

USE +

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_CREATE

DBMGMT_EXTERNAL_MYSQL_DB_CONNECTOR_DELETE

nenhum

CreateExternalMySqlDatabaseConnector (também precisa de use dbmgmt-external-mysql-databases)

DeleteExternalMySqlDatabaseConnector (também precisa de use dbmgmt-external-mysql-databases)

Permissões Exigidas para cada Operação de API

A tabela a seguir lista as operações da API em ordem alfabética.

Observação

Se estiver usando credenciais nomeadas para executar uma operação de API pertencente ao Diagnostics & Management para Bancos de Dados Oracle e Sistemas de Banco de Dados Externo, a permissão DBMGMT_NAMED_CREDENTIAL_READ poderá ser necessária, além das permissões listadas para a operação de API.

Para obter informações sobre permissões, consulte Permissões.

Operação de API Permissões Obrigatórias para Usar a Operação

AbortPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_UPDATE ou 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 ou 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

As permissões necessárias dependem do tipo de SQL para jobs SQL e do tipo de recurso.

  • Consulta: Com a permissão DBMGMT_JOB_CREATE, a seguinte permissão CONTENT_READ é necessária:
    • Para um Banco de Dados Gerenciado: DBMGMT_MANAGED_DB_CONTENT_READ
    • Para um Grupo de Bancos de Dados: DBMGMT_MANAGED_DB_GROUP_DB_CONTENT_READ
  • DDL/DML/PLSQL: Com a permissão DBMGMT_JOB_CREATE, as seguintes permissões CONTENT_READ e CONTENT_WRITE são obrigatórias:
    • Para um Banco de Dados Gerenciado: DBMGMT_MANAGED_DB_CONTENT_READ e DBMGMT_MANAGED_DB_CONTENT_WRITE
    • Para um Grupo de Bancos de Dados: 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 ou 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

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um Grupo de Bancos de Dados específico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetDataguardMetrics

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um Grupo de Bancos de Dados específico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHaOverviewMetrics

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para uma frota de Bancos de Dados Gerenciados de Alta Disponibilidade em um Grupo de Bancos de Dados específico: DBMGMT_MANAGED_DB_READ e DBMGMT_MANAGED_DB_GROUP_READ

GetDatabaseFleetHealthMetrics

  • Para uma frota de Bancos de Dados Gerenciados em um compartimento específico: DBMGMT_MANAGED_DB_READ

  • Para uma frota de Bancos de Dados Gerenciados em um Grupo de Bancos de Dados específico: 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 ou DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchManagement

DBMGMT_DBLM_PATCH_MANAGEMENT_READ

GetPatchOperation

DBMGMT_DBLM_PATCH_MANAGEMENT_READ ou DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTask

DBMGMT_DBLM_PATCH_MANAGEMENT_READ ou DBMGMT_DBLM_PATCH_OPERATION_READ

GetPatchTaskStep

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

GetSoftwareImage

DBMGMT_DBLM_PATCH_MANAGEMENT_READ ou 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 (para Detecção de Vulnerabilidade)

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 ou DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTasks

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT ou DBMGMT_DBLM_PATCH_OPERATION_INSPECT

ListPatchTaskSteps

DBMGMT_DBLM_PATCH_MANAGEMENT_INSPECT ou 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 ou 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 (para Detecção de Vulnerabilidade)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequestLogs

DBMGMT_WORK_REQUEST_READ

ListWorkRequestLogs (para Detecção de Vulnerabilidade)

DBMGMT_DBLM_WORK_REQUEST_INSPECT

ListWorkRequests

DBMGMT_WORK_REQUEST_INSPECT

ListWorkRequests (para Detecção de Vulnerabilidade)

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 ou DBMGMT_DBLM_PATCH_OPERATION_CREATE

PublishSqlResult

DBMGMT_SPA_TASK_PUBLISH_SQL_RESULT

QuickValidations

DBMGMT_DBLM_PATCH_MANAGEMENT_CREATE ou 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 ou 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 ou 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 ou 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 ou 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