Help Center/ Data Admin Service/ User Guide/ Logging In to Databases Shared by Others
Updated on 2023-03-07 GMT+08:00

Logging In to Databases Shared by Others

Scenarios

You have a database instance and want to share it with another account or another user of the same account, but you do not want this other account or user to know the password of the shared login, or view your database instances besides the shared one.

Prerequisites

  • There are two accounts, or one account and two IAM users.
  • You have obtained the ID of the IAM user.
  • You have logged in to the DAS console.

Use Constraints

  • Users having shared database logins cannot add databases or users.
  • Shared databases do not have the data tracking, rollback, and background task features.

Procedure

  1. Log in to the DAS console using the username and password of an IAM user.
  2. On the overview page, click Go to Development Tool.
  3. In the right pane, click the Database Logins Shared by Others tab.
  4. Click View My User ID. On the displayed page, copy the user ID.
  5. Log in to the DAS console using the username and password of the account.
  6. On the overview page, click Go to Development Tool.
  7. On the My Database Logins tab, locate the login you want to share and click the number in the Additional Users column.
  8. On the displayed View Additional Users page, click Add User.
  9. On the displayed Add User page, select the adding method.

    • Manual input: Enter the ID of the user that you want to share your database login with. If multiple users need to be added, separate their IDs with semicolons (;).
    • Synchronize IAM account: Select another IAM user of the current account.
    • Synchronize EPS user: Select the target users from the group of the enterprise project.

  10. Confirm the settings and click OK.
  11. Return to the DAS console and check whether the users are successfully added.
  12. Click Log In to log in to the shared database.