授权信息

更新时间: 2023-11-21 19:34:41
访问控制(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:CreateDBClusterCreateDBClusterWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DiskEncryption
adb:CreateElasticPlanCreateElasticPlanWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:CreateSparkTemplateCreateSparkTemplateWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbclusterlakeversion/*
adb:DeleteElasticPlanDeleteElasticPlanWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:DeleteSparkTemplateDeleteSparkTemplateRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DeleteSparkTemplateFileDeleteSparkTemplateFileWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAdbMySqlColumnsDescribeAdbMySqlColumnsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAllDataSourceDescribeTablesRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:DescribeAllDataSourceDescribeColumnsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:DescribeAllDataSourceDescribeAllDataSourceRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeAllDataSourceDescribeSchemasRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClusterAttributeDescribeDBClusterAttributeRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeDBClustersDescribeDBClustersRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:DescribeElasticPlanAttributeDescribeElasticPlanAttributeList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:DescribeElasticPlanJobsDescribeElasticPlanJobsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/*
adb:DescribeElasticPlanSpecificationsDescribeElasticPlanSpecificationsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/*
adb:DescribeElasticPlansDescribeElasticPlansList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/*
adb:DescribeSqlPatternDescribeSqlPatternList
DBClusterLakeVersion
acs:adb:{#Region}:{#AccountId}:dbcluster/{#DBClusterId}
adb:DisableElasticPlanDisableElasticPlanWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:EnableElasticPlanEnableElasticPlanWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:ExistRunningSQLEngineExistRunningSQLEngineRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}
adb:GetSparkAppAttemptLogGetSparkAppAttemptLogRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:GetSparkAppInfoGetSparkAppInfoRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:GetSparkAppLogGetSparkAppLogRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:GetSparkAppStateGetSparkAppStateRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:GetSparkAppWebUiAddressGetSparkAppWebUiAddressRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:GetSparkConfigLogPathGetSparkConfigLogPathRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:GetSparkDefinitionsGetSparkDefinitionsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbclusterlakeversion/{#DBClusterId}
adb:GetSparkLogAnalyzeTaskGetSparkLogAnalyzeTaskRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/task/{#SparkTaskId}
adb:GetSparkSQLEngineStateGetSparkSQLEngineStateRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}
adb:GetSparkTemplateFileContentGetSparkTemplateFileContentRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:GetSparkTemplateFolderTreeGetSparkTemplateFolderTreeRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:GetSparkTemplateFullTreeGetSparkTemplateFullTreeRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:GetTableGetTableRead
全部资源
acs:adb:*:{#accountId}:*
adb:GetTableColumnsGetTableColumnsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:GetTableDDLGetTableDDLRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:GetTableObjectsGetTableObjectsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:GetViewDDLGetViewDDLRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:GetViewObjectsGetViewObjectsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}
adb:KillSparkAppKillSparkAppRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}/sparkapp/{#SparkAppId}
adb:KillSparkLogAnalyzeTaskKillSparkLogAnalyzeTaskWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/task/{#SparkTaskId}
adb:KillSparkSQLEngineKillSparkSQLEngineWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}
adb:ListSparkAppAttemptsListSparkAppAttemptsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ListSparkAppsListSparkAppsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ListSparkLogAnalyzeTasksListSparkLogAnalyzeTasksList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ListSparkTemplateFileIdsListSparkTemplateFileIdsList
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterModifyDBClusterWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyDBClusterDescriptionModifyDBClusterDescriptionWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:ModifyElasticPlanModifyElasticPlanWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:DBClusterLakeVersion/DBClusterLakeVersionId
adb:RenameSparkTemplateFileRenameSparkTemplateFileWrite
acs:adb:{#regionId}:{#accountId}:*
adb:SetSparkAppLogRootPathSetSparkAppLogRootPathWrite
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:StartSparkSQLEngineStartSparkSQLEngineRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}
adb:SubmitSparkAppSubmitSparkAppRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}/resourcegroup/{#ResourceGroup}
adb:SubmitSparkLogAnalyzeTaskSubmitSparkLogAnalyzeTaskRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#accountId}:dbcluster/{#DBClusterId}
adb:getDatabaseObjectsByFilterGetDatabaseObjectsRead
DBClusterLakeVersion
acs:adb:{#regionId}:{#AccountId}:dbcluster/{#DBClusterId}

资源(Resource)

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

条件(Condition)

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

相关操作

您可以创建自定义权限策略,并将权限策略授予RAM用户、RAM用户组或RAM角色。具体操作如下:
阿里云首页 云原生数据仓库AnalyticDB MySQL版 相关技术圈