This document describes how to create and manage the LOGIN user in a database of ApsaraDB for SQL Server.
|The operation described in this document is applicable only to instances of RDS for SQL Server 2012 and later versions.|
Create a LOGIN user
Run the following command to create a LOGIN user.
CREATE LOGIN Test11 WITH PASSWORD=N'4C9ED138-C8F5-4185-9E7A-8325465CA9B7'
When the LOGIN user is being created, it is assigned permissions at the server level and database level. The Message area shows the following information.
Modify a LOGIN user
Run the following commands to modify a LOGIN user.
ALTER LOGIN Test11 WITH PASSWORD=N'123', CHECK_POLICY=OFF
The following error is returned if you attempt to modify a LOGIN user that is not created by you.
Delete a LOGIN user
Run the following command to delete a LOGIN user:
DROP LOGIN Test11
An error is returned if you attempt to delete a LOGIN user that is not created by you.