Updated on 2024-08-29 GMT+08:00

Creating a Login Name

DAS allows you to create login accounts with different permissions for accessing databases to enhance data management security.

Procedure

  1. Log in to the DAS console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner, and under Databases, click Data Admin Service.
  4. In the navigation pane on the left, choose Development Tool.

    You can also click Go to Development Tool on the overview page.

  5. Locate the DB instance that you want to log in to and click Log In in the Operation column.
  6. On the top menu bar, choose Account Management > Login Name.
  7. Click Create Login Name.

    Figure 1 Creating a login name

  8. Set parameters on the Basic Settings, Server Roles, User Mapping, Securables, and Status tab pages separately, and click Save.

    Figure 2 Creating a login name

    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

    The confirm password must be the same as the password you set.

    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 Roles

    Configure server roles for the login name.

    User Mapping

    Configure specific permissions for the login name on specific databases.

    NOTE:

    If you click User Mapping and select the required databases, the system will delete user information in the User column and create new users accordingly.

    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.

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

    Figure 3 Login name list