This topic describes how to create accounts and databases for an ApsaraDB RDS instance that runs SQL Server 2017 EE or 2019 EE.
Prerequisites
Your RDS instance runs SQL Server 2017 EE or 2019 EE.
Note For more information about how to create accounts and databases for an RDS instance
that runs a different SQL Server version, see the following topics:
Precautions
- Databases on the same RDS instance share all the resources that belong to the RDS instance. You can manage standard accounts and databases by using SQL statements.
- You must follow the principle of least privilege to create accounts and grant the read-only permissions or the read and write permissions to the accounts based on the required roles. If necessary, you can create more than one account and grant each account only the permissions to access the data of specific databases within its authorized workloads. If an account does not need to write data to a database, you must grant only the read-only permissions on the database to the account.
- For security purposes, we recommend that you configure strong passwords for the created accounts and change the passwords on a regular basis.
Create an account
Create a database
FAQ
After I create accounts on my primary RDS instance, can I manage the accounts on its read-only RDS instances?
No, although the accounts created on your primary RDS instance are synchronized to its read-only RDS instances, you cannot manage the accounts on the read-only RDS instances. The accounts have only read permissions on the read-only RDS instances.
References
- For more information about how to create an account for an RDS instance by calling an API operation, see Create an account.
- For more information about how to create a database for an RDS instance by calling an API operation, see Create database.
- For more information about how to create databases and accounts for an RDS instance
that runs a different database engine, see the following topics:
- Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2012, 2016, 2017 SE, or 2019 SE
- Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2008 R2
- Create databases and accounts for an ApsaraDB RDS for PostgreSQL instance
- Create databases and accounts for an ApsaraDB RDS for MariaDB TX instance