Help Center> GaussDB> User Guide> Permissions Management> Creating a User and Granting GaussDB(for MySQL) Permissions

Creating a User and Granting GaussDB(for MySQL) Permissions

This chapter describes how to use IAM to implement fine-grained permissions control for your GaussDB(for MySQL) resources. With IAM, you can:

  • Create IAM users for employees based on your enterprise's organizational structure. Each IAM user will have their own security credentials for accessing GaussDB(for MySQL) resources.
  • Grant only the permissions required for users to perform a specific task.
  • Entrust a HUAWEI CLOUD account or cloud service to perform efficient O&M on your GaussDB(for MySQL) resources.

If your HUAWEI CLOUD account does not require individual IAM users, skip this chapter.

This section describes the procedure for granting permissions (see Figure 1).

Prerequisites

Learn about the permissions (see system-defined policies) supported by GaussDB(for MySQL) and choose policies or roles according to your requirements. For the permissions of other services, see Permissions Policies.

Process Flow

Figure 1 Process of granting GaussDB(for MySQL) permissions
  1. Create a user group and assign permissions to it.

    Create a user group on the IAM console, and attach the GaussDB ReadOnlyAccess policy to the group.

  2. Create an IAM user.

    Create a user on the IAM console and add the user to the group created in 1.

  3. Log in and verify permissions.

    Log in to the GaussDB(for MySQL) console by using the created user, and verify that the user only has read permissions for GaussDB(for MySQL).

    • Choose Service List > GaussDB(for MySQL) and click Buy DB Instance. If a message appears indicating that you have insufficient permissions to perform the operation, the GaussDB ReadOnlyAccess policy has already taken effect.
    • Choose any other service in Service List. If a message appears indicating that you have insufficient permissions to access the service, the GaussDB ReadOnlyAccess policy has already taken effect.