ALIYUN::RDS::Account is used to create a database account for an ApsaraDB for RDS instance.

Syntax

{
  "Type": "ALIYUN::RDS::Account",
  "Properties": {
    "AccountDescription": String,
    "DBInstanceId": String,
    "AccountPassword": String,
    "AccountType": String,
    "AccountName": String
  }
}

Properties

Property Type Required Editable Description Constraint
AccountDescription String No Yes The description of the database account. The description must be 2 to 256 characters in length and can contain letters, digits, underscores (_), and hyphens(-). It must start with a letter.
DBInstanceId String Yes No The ID of the instance. None
AccountPassword String Yes No The password of the database account. The password must be 8 to 32 characters in length and must contain at least three of the following character types: uppercase letters, lowercase letters, digits, and special characters. Special characters include
! @#$&%^*()_+-=
AccountType String No No The type of the database account. Default value: Normal. Valid values:
  • Normal: standard account
  • Super: privileged account
    Note Privileged accounts in ApsaraDB RDS for SQL Server instances cannot be deleted.
AccountName String Yes No The name of the database account. None

Response parameters

Fn::GetAtt

AccountName: the name of the database account.

Examples

  • YAMLformat 

    ROSTemplateFormatVersion: '2015-09-01'
Parameters:
  DBInstanceId:
    Type: String
    AssociationProperty: ALIYUN::RDS::Instance::InstanceId
Resources:
  Account:
    Type: ALIYUN::RDS::Account
    Properties:
      DBInstanceId:
        Ref: DBInstanceId
      AccountType: Normal
      AccountPassword: Admin@123!
      AccountName: Test
Outputs: {}

  • JSONformat 

    {
  "ROSTemplateFormatVersion": "2015-09-01",
  "Parameters": {
    "DBInstanceId": {
      "Type": "String",
      "AssociationProperty": "ALIYUN::RDS::Instance::InstanceId"
    }
  },
  "Resources": {
    "Account": {
      "Type": "ALIYUN::RDS::Account",
      "Properties": {
        "DBInstanceId": {
          "Ref": "DBInstanceId"
        },
        "AccountType": "Normal",
        "AccountPassword": "Admin@123!",
        "AccountName": "Test"
      }
    }
  },
  "Outputs": {
  }
}