Details for Operations Insights

This topic covers details for writing policies to control access to the Operations Insights service.

Resource-Types

Individual Resource-Types

opsi-database-insights

Aggregate Resource-Types

opsi-family

Comments

See the table in Permissions Required for Each API Operation for details of the API operations covered by each verb, for each individual resource-type.

Details for Verb + Resource-Type Combinations

The following tables show the permissions and API operations covered by each verb. The level of access is cumulative as you go from inspect > read > use > manage. A plus sign (+) in a table cell indicates incremental access compared to the cell directly above it, whereas "no extra" indicates no incremental access.

opsi-database-insights
Verbs Permissions APIs Fully Covered APIs Partially Covered
inspect

OPSI_DATABASE_INSIGHT_INSPECT

ListDatabaseInsights

none

read

INSPECT +

OPSI_DATABASE_INSIGHT_RESOURCE_CAPACITY_TREND_READ

OPSI_DATABASE_INSIGHT_RESOURCE_FORECAST_TREND_READ

OPSI_DATABASE_INSIGHT_RESOURCE_STATISTICS_READ

OPSI_DATABASE_INSIGHT_RESOURCE_USAGE_READ

OPSI_DATABASE_INSIGHT_RESOURCE_USAGE_TREND_READ

OPSI_DATABASE_INSIGHT_RESOURCE_UTILIZATION_INSIGHT_READ

OPSI_DATABASE_INSIGHT_SQL_INSIGHTS_READ

OPSI_DATABASE_INSIGHT_SQL_PLAN_INSIGHTS_READ

OPSI_DATABASE_INSIGHT_SQL_PLANS_READ

OPSI_DATABASE_INSIGHT_SQL_RESPONSE_TIME_DISTRIBUTIONS_READ

OPSI_DATABASE_INSIGHT_SQL_SEARCH_READ

OPSI_DATABASE_INSIGHT_SQL_STATISTICS_READ

OPSI_DATABASE_INSIGHT_SQL_STATISTICS_TIME_SERIES_BY_PLAN_READ

OPSI_DATABASE_INSIGHT_SQL_STATISTICS_TIME_SERIES_READ

OPSI_DATABASE_INSIGHT_SQL_TEXTS_READ

ListSqlPlans

ListSqlSearches

ListSqlTexts

SummarizeDatabaseInsightResourceCapacityTrend

SummarizeDatabaseInsightResourceForecastTrend

SummarizeDatabaseInsightResourceStatistics

SummarizeDatabaseInsightResourceUsage

SummarizeDatabaseInsightResourceUsageTrend

SummarizeDatabaseInsightResourceUtilizationInsight

SummarizeSqlInsights

SummarizeSqlPlanInsights

SummarizeSqlResponseTimeDistributions

SummarizeSqlStatistics

SummarizeSqlStatisticsTimeSeries

SummarizeSqlStatisticsTimeSeriesByPlan

none

use

READ +

OPSI_DATABASE_INSIGHT_SQL_BUCKET_INGEST

OPSI_DATABASE_INSIGHT_SQL_PLAN_LINE_INGEST

OPSI_DATABASE_INSIGHT_SQL_TEXT_INGEST

IngestSqlBucket

IngestSqlPlanLines

IngestSqlText

none

manage

USE +

no extra

no extra

none

Permissions Required for Each API Operation

The following table lists the API operations in alphabetical order.

For information about permissions, see Permissions.

API Operation Permissions Required to Use the Operation
IngestSqlBucket OPSI_DATABASE_INSIGHT_SQL_BUCKET_INGEST
IngestSqlPlanLines OPSI_DATABASE_INSIGHT_SQL_PLAN_LINES_INGEST
IngestSqlText OPSI_DATABASE_INSIGHT_SQL_TEXT_INGEST
ListDatabaseInsights OPSI_DATABASE_INSIGHT_INSPECT
ListSqlPlans OPSI_DATABASE_INSIGHT_SQL_PLANS_READ
ListSqlSearches OPSI_DATABASE_INSIGHT_SQL_SEARCH_READ
ListSqlTexts OPSI_DATABASE_INSIGHT_SQL_TEXTS_READ
SummarizeDatabaseInsightResourceCapacityTrend OPSI_DATABASE_INSIGHT_RESOURCE_CAPACITY_TREND_READ
SummarizeDatabaseInsightResourceForecastTrend OPSI_DATABASE_INSIGHT_RESOURCE_FORECAST_TREND_READ
SummarizeDatabaseInsightResourceStatistics OPSI_DATABASE_INSIGHT_RESOURCE_STATISTICS_READ
SummarizeDatabaseInsightResourceUsage OPSI_DATABASE_INSIGHT_RESOURCE_USAGE_READ
SummarizeDatabaseInsightResourceUsageTrend OPSI_DATABASE_INSIGHT_RESOURCE_USAGE_TREND_READ
SummarizeDatabaseInsightResourceUtilizationInsight OPSI_DATABASE_INSIGHT_RESOURCE_UTILIZATION_INSIGHT_READ
SummarizeSqlInsights OPSI_DATABASE_INSIGHT_SQL_INSIGHTS_READ
SummarizeSqlPlanInsights OPSI_DATABASE_INSIGHT_SQL_PLAN_INSIGHTS_READ
SummarizeSqlResponseTimeDistributions OPSI_DATABASE_INSIGHT_SQL_RESPONSE_TIME_DISTRIBUTIONS_READ
SummarizeSqlStatistics OPSI_DATABASE_INSIGHT_SQL_STATISTICS_READ
SummarizeSqlStatisticsTimeSeries OPSI_DATABASE_INSIGHT_SQL_STATISTICS_TIME_SERIES_READ
SummarizeSqlStatisticsTimeSeriesByPlan OPSI_DATABASE_INSIGHT_SQL_STATISTICS_TIME_SERIES_BY_PLAN_READ