AnalyticDB for MySQL Data Lakehouse Edition (V3.0) allows you to associate your standard database account with your Resource Access Management (RAM) user. Then, you can perform SQL development in the AnalyticDB for MySQL console as a RAM user. You can also use the standard database account to access Object Storage Service (OSS) external tables. This topic describes how to associate or disassociate your standard database account with or from your RAM user.

Precautions

  • Standard database accounts can be associated with RAM users only for AnalyticDB for MySQL Data Lakehouse Edition (V3.0) clusters.
  • Only standard database accounts can be associated with RAM users. This feature is not supported for privileged database accounts.
  • By default, privileged database accounts are associated with Alibaba Cloud accounts.

Mapping scenarios between standard database accounts and RAM users

  • SQL editor: When you log on to the SQL editor as a RAM user, you must map the RAM user to a standard database account of AnalyticDB for MySQL to read and write tables.
  • JDBC connection: When you use a standard database account of AnalyticDB for MySQL to connect to a database in JDBC mode, you must map the standard database account to a RAM user to read and write external tables such as OSS external tables.
  • Spark application: When you start a Spark application as a RAM user, you must map the RAM user to a standard database account of AnalyticDB for MySQL to connect to the AnalyticDB for MySQL database.

Prerequisites

A standard database account is created. For more information about how to create a standard database account, see Create a database account.

Associate a database account with a RAM user

  1. Log on to the AnalyticDB for MySQL console.
  2. In the upper-left corner of the page, select the region where the cluster resides.
  3. In the left-side navigation pane, click Clusters.
  4. On the Data Lakehouse Edition (V3.0) tab, find the cluster and click its Cluster ID.
  5. In the left-side navigation pane, click Accounts.
  6. Find the database account that you want to manage and choose RAM User > Associate in the Actions column.
  7. In the Associate with RAM User dialog box, enter a RAM user ID.
    Note The RAM user ID is the UID of your RAM user that can be found on the Users page of the RAM console. For more information, see View the basic information about a RAM user.
  8. Click OK.

Disassociate a database account from a RAM user

Find the database account that you want to manage and choose RAM User > Disassociate in the Actions column.