This document describes how to create and manage the LOGIN user in a database of ApsaraDB for SQL Server.

Note
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.