全部产品
Search
文档中心

云原生数据仓库AnalyticDB:授权信息

更新时间:Aug 30, 2024
访问控制(RAM)是阿里云提供的管理用户身份与资源访问权限的服务。使用RAM可以让您避免与其他用户共享阿里云账号密钥,并可按需为用户授予最小权限。RAM中使用权限策略描述授权的具体内容。
本文为您介绍云原生数据仓库AnalyticDB MySQL版(ADB)为RAM权限策略定义的操作(Action)、资源(Resource)和条件(Condition)。云原生数据仓库AnalyticDB MySQL版(ADB)的RAM代码(RamCode)为adb,支持的授权粒度为RESOURCE

权限策略通用结构

权限策略支持JSON格式,其通用结构如下:
{
  "Version": "1",
  "Statement": [
    {
      "Effect": "<Effect>",
      "Action": "<Action>",
      "Resource": "<Resource>",
      "Condition": {
        "<Condition_operator>": {
          "<Condition_key>": [
            "<Condition_value>"
          ]
        }
      }
    }
  ]
}
各字段含义如下:
  • Effect:权限策略效果。取值:Allow(允许)、Deny(拒绝)。
  • Action:授予允许或拒绝权限的具体操作。具体信息,请参见操作(Action)
  • Resource:受操作影响的具体对象,您可以使用资源ARN来描述指定资源。具体信息,请参见资源(Resource)
  • Condition:指授权生效的条件。可选字段。具体信息,请参见条件(Condition)
    • Condition_operator:条件运算符,不同类型的条件对应不同的条件运算符。具体信息,请参见权限策略基本元素
    • Condition_key:条件关键字。
    • Condition_value:条件关键字对应的值。

操作(Action)

下表是云原生数据仓库AnalyticDB MySQL版(ADB)定义的操作,这些操作可以在RAM权限策略语句的Action元素中使用,用来授予执行该操作的权限。下面对表中的具体项提供说明:
  • 操作:是指具体的权限点。
  • API:是指操作对应的API接口。
  • 访问级别:是指每个操作的访问级别,取值为写入(Write)、读取(Read)或列出(List)。
  • 资源类型:是指操作中支持授权的资源类型。具体说明如下:
    • 对于必选的资源类型,用背景高亮的方式表示。
    • 对于不支持资源级授权的操作,用全部资源表示。
  • 条件关键字:是指云产品自身定义的条件关键字。该列不体现适用于任何操作的通用条件关键字
  • 关联操作:是指成功执行操作所需要的其他权限。操作者必须同时具备关联操作的权限,操作才能成功。
操作API访问级别资源类型条件关键字关联操作
adb:DescribeAutoRenewAttributeDescribeAutoRenewAttributeget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeOperatorPermissionDescribeOperatorPermissionget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ModifyClusterConnectionStringModifyClusterConnectionStringupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterPerformanceDescribeDBClusterPerformancelist
全部资源
*
adb:ModifyDBClusterSSLModifyDBClusterSSLupdate
全部资源
*
adb:EnableSSL
adb:DescribeDBClustersDescribeDBClustersget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/*
adb:DescribeDiagnosisTasksDescribeDiagnosisTasksget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAvailableResourceDescribeAvailableResourceget
全部资源
*
adb:DescribeTableDetailDescribeTableDetailget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterDescriptionModifyDBClusterDescriptionupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ApplyAdviceByIdApplyAdviceByIdupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAuditLogConfigDescribeAuditLogConfigget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBResourceGroupModifyDBResourceGroupupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ModifyAutoRenewAttributeModifyAutoRenewAttributeupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ReleaseClusterPublicConnectionReleaseClusterPublicConnectiondelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:CreateDBResourcePoolCreateDBResourcePoolcreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAccountsDescribeAccountsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeDBResourcePoolDescribeDBResourcePoolget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DeleteElasticPlanDeleteElasticPlandelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DeleteDBClusterDeleteDBClusterdelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:MigrateDBClusterMigrateDBClusterupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeTableStatisticsDescribeTableStatisticsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterModifyDBClusterupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeDBClusterSpaceSummaryDescribeDBClusterSpaceSummaryget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:KillProcessKillProcessdelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDiagnosisRecordsDescribeDiagnosisRecordsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterAccessWhiteListModifyDBClusterAccessWhiteListupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyMaintenanceActionModifyMaintenanceActionupdate
全部资源
*
adb:CreateElasticPlanCreateElasticPlancreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeKernelVersionDescribeKernelVersionlist
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterAccessWhiteListDescribeDBClusterAccessWhiteListget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeBackupsDescribeBackupsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBResourceGroupDescribeDBResourceGroupget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeDiagnosisSQLInfoDescribeDiagnosisSQLInfoget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDiagnosisDimensionsDescribeDiagnosisDimensionsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifySQAConfigModifySQAConfigupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeSqlPatternDescribeSqlPatternget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDownloadRecordsDescribeDownloadRecordsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:UnbindDBResourcePoolWithUserUnbindDBResourcePoolWithUserupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAuditLogRecordsDescribeAuditLogRecordsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyBackupPolicyModifyBackupPolicyupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeLoadTasksRecordsDescribeLoadTasksRecordsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeComputeResourceDescribeComputeResourceget
全部资源
*
adb:DescribeTaskInfoDescribeTaskInfoget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBResourcePoolModifyDBResourcePoolupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeElasticDailyPlanDescribeElasticDailyPlanget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeProcessListDescribeProcessListget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:TagResourcesTagResourcescreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:GrantOperatorPermissionGrantOperatorPermissionupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ModifyAuditLogConfigModifyAuditLogConfigupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeExcessivePrimaryKeysDescribeExcessivePrimaryKeysget
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeTablePartitionDiagnoseDescribeTablePartitionDiagnoseget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:BatchApplyAdviceByIdListBatchApplyAdviceByIdListupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeElasticPlanDescribeElasticPlanget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeMaintenanceActionDescribeMaintenanceActionget
全部资源
*
adb:DescribeAllDataSourceDescribeAllDataSourceget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeEIURangeDescribeEIURangeget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DeleteAccountDeleteAccountdelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:BindDBResourceGroupWithUserBindDBResourceGroupWithUserupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeSchemasDescribeSchemasget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeColumnsDescribeColumnsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyLogBackupPolicyModifyLogBackupPolicyupdate
全部资源
*
adb:DescribeResubmitConfigDescribeResubmitConfigget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeTablesDescribeTablesget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterPayTypeModifyDBClusterPayTypeupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeSQLPlanDescribeSQLPlanget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:UntagResourcesUntagResourcesdelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:AllocateClusterPublicConnectionAllocateClusterPublicConnectionupdate
DBCluster
acs:adb:*:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeSQLPatternsDescribeSQLPatternsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAvailableAdvicesDescribeAvailableAdvicesget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribePatternPerformanceDescribePatternPerformanceget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DeleteDBResourceGroupDeleteDBResourceGroupdelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DetachUserENIDetachUserENIupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:UnbindDBResourceGroupWithUserUnbindDBResourceGroupWithUserupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ModifyDBClusterResourceGroupModifyDBClusterResourceGroupupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:AttachUserENIAttachUserENIupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterHealthStatusDescribeDBClusterHealthStatusget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:CreateAccountCreateAccountcreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:CreateDBClusterCreateDBClustercreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/*
adb:DiskEncryption
adb:EnableSSL
adb:DescribeDBClusterNetInfoDescribeDBClusterNetInfoget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:UpgradeKernelVersionUpgradeKernelVersionupdate
全部资源
*
adb:DescribeSQAConfigDescribeSQAConfigget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterAttributeDescribeDBClusterAttributeget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeInclinedTablesDescribeInclinedTablesget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAppliedAdvicesDescribeAppliedAdvicesget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterResourcePoolPerformanceDescribeDBClusterResourcePoolPerformanceget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyAccountDescriptionModifyAccountDescriptionupdate
全部资源
*
adb:EnableAdviceServiceEnableAdviceServiceupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:CreateDBResourceGroupCreateDBResourceGroupcreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:RevokeOperatorPermissionRevokeOperatorPermissionupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeDBClusterSSLDescribeDBClusterSSLget
全部资源
*
adb:DescribeAdviceServiceEnabledDescribeAdviceServiceEnabledget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDiagnosisMonitorPerformanceDescribeDiagnosisMonitorPerformanceget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyResubmitConfigModifyResubmitConfigupdate
全部资源
*
adb:DeleteDBResourcePoolDeleteDBResourcePooldelete
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DisableAdviceServiceDisableAdviceServiceupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterMaintainTimeModifyDBClusterMaintainTimeupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ListTagResourcesListTagResourcesget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DownloadDiagnosisRecordsDownloadDiagnosisRecordscreate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyElasticPlanModifyElasticPlanupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeBackupPolicyDescribeBackupPolicyget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:ResetAccountPasswordResetAccountPasswordupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
adb:DescribeTableAccessCountDescribeTableAccessCountget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:BindDBResourcePoolWithUserBindDBResourcePoolWithUserupdate
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeConnectionCountRecordsDescribeConnectionCountRecordsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeSQLPlanTaskDescribeSQLPlanTaskget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAllAccountsDescribeAllAccountsget
DBCluster
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}

资源(Resource)

下表是云原生数据仓库AnalyticDB MySQL版(ADB)定义的资源,这些资源可以在RAM权限策略语句的Resource元素中使用,用来授予对该资源执行具体操作的权限。 其中,资源ARN是资源在阿里云上的唯一标识。具体说明如下:
  • {#}为变量标识,需要您替换为实际值。例如:{#ramcode}需要您替换为实际的云服务RAM代码。
  • *表示全部。例如:
    • {#resourceType}*时:表示全部资源。
    • {#regionId}*时:表示全部地域。
    • {#accountId}*时:表示全部阿里云账号。
资源类型资源ARN
DBClusteracs:adb:{#regionId}:{#accountId}:dbcluster/{#dbclusterId}
DBClusteracs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
DBClusterLakeVersionacs:adb:{#Region}:{#AccountId}:dbcluster/{#DBClusterId}
DBClusteracs:adb:{#regionId}:{#accountId}:dbcluster/*
DBClusteracs:adb:{#regionId}:{#accountId}:null/*
DBClusteracs:adb:*:{#accountId}:dbcluster/{#dbclusterId}
DBClusterLakeVersionacs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}

条件(Condition)

下表是云原生数据仓库AnalyticDB MySQL版(ADB)定义的产品级条件关键字,这些条件关键字可以在RAM权限策略语句的Condition元素中使用,用来描述授予权限的条件。以下仅列举产品级的条件关键字,阿里云定义的通用条件关键字也同样适用云原生数据仓库AnalyticDB MySQL版(ADB)
其中,数据类型决定了您可以使用哪些条件运算符将请求中的值与权限策略语句中的值进行比较。您必须使用与数据类型匹配的条件运算符,否则无法匹配策略语句,授权行为无效。数据类型与条件运算符的对应关系,请参见条件操作类型
条件关键字描述类型
adb:DiskEncryption是否开启云盘加密String
adb:EnableSSL是否开启SSL加密链接String

相关操作

您可以创建自定义权限策略,并将权限策略授予RAM用户、RAM用户组或RAM角色。具体操作如下: