Creating a Login Name

Scenarios

You can create login accounts with different permissions for databases to improve data management security.

Procedure

1. On the top menu bar, choose Account Management > Login Name.
2. On the displayed page, click Create Login Name. Set parameters on the Basic Settings, Server Roles, User Mapping, Securables, and Status pages by referring to Table 1, and click Save.

   Table 1 Login name information

   Parameter	Description
   Login Name	Name of the account for logging in to the instance
   Authentication Type	Select Microsoft SQL Server Authentication by default.
   Password	Password of the login account. The password: Can contain 8 to 128 characters. Must contain at least three types of lowercase letters, uppercase letters, digits, and the following special characters: ~!@#%^*-_=+?$ Cannot contain the login name. Cannot be a weak password.
   Confirm Password	-
   Enforce Password Policy	If you select this option, the password must meet security rules of the SQL Server instance.
   Default Database	Database that is logged in by default
   Default Language	Default language of the database
   Server Role	Configure server roles for the login name.
   User Mapping	Configure specific permissions for the login name on specific databases.
   Securables	Configure server-level permissions for the login name.
   Status	If you select Enable, you allow the login name to log in to the current instance. If you select Disable, you do not allow the login name to log in to the instance.

3. Click Back to Login Name List and view the newly-added login name.
4. In the login name list, edit, rename, or delete the created login names as required.