AnalyticDB for MySQL supports the following database account types: privileged and standard. You can use a privileged account to manage all the standard accounts and databases. For standard accounts, you must manually create and grant permissions to perform database operations.

Create and grant permissions to a standard account

You can only create and manage standard accounts through SQL statements.

  • For more information about how to create a standard account, see CREATE USER.
  • For more information about how to grant permissions to a standard account, see GRANT.
  • For more information about how to revoke the permissions of a standard account, see REVOKE.
  • For more information about how to modify the name of a database account, see RENAME USER.
  • For more information about how to grant permissions to a standard account, see DROP USER.