Updated on 2022-08-16 GMT+08:00

GaussDB(DWS) Permissions Management

If you need to assign different permissions to employees in your enterprise to access your Huawei Cloud GaussDB(DWS) resources, IAM is a good choice for fine-grained permissions management. IAM provides identity authentication, permissions management, and access control, helping you secure access to your Huawei Cloud resources.

With IAM, you can use your Huawei Cloud account to create IAM users for your employees, and assign permissions to the users to control their access to specific resource types. For example, some software developers in your enterprise need to use GaussDB(DWS) resources but must not delete them or perform any high-risk operations. To this end, you can create IAM users for the software developers and grant them only the permissions required for using GaussDB(DWS) resources.

If your Huawei Cloud account does not need individual IAM users for permissions management, you may skip this section.

IAM can be used free of charge. You pay only for the resources in your account. For more information about IAM, see "Service Overview" in the Identity and Access Management User Guide.

Supported System Policies

By default, new IAM users do not have permissions assigned. You need to add a user to one or more groups, and attach permissions policies or roles to these groups. Users inherit permissions from the groups to which they are added and can perform specified operations on cloud services.

GaussDB(DWS) is a project-level service deployed and accessed in specific physical regions. To assign GaussDB(DWS) permissions to a user group, specify the scope as region-specific projects and select projects for the permissions to take effect. If All projects is selected, the permissions will take effect for the user group in all region-specific projects. When accessing GaussDB(DWS), the users need to switch to a region where they have been authorized to use GaussDB(DWS).

  • Role: IAM initially provides a coarse-grained authorization mechanism to define permissions based on users' job responsibilities. This mechanism provides only a limited number of service-level roles for authorization. When using roles to grant permissions, you must also assign other roles on which the permissions depend to take effect. However, roles are not an ideal choice for fine-grained authorization and secure access control.
  • Policies: A type of fine-grained authorization mechanism that defines permissions required to perform operations on specific cloud resources under certain conditions. This mechanism allows for more flexible policy-based authorization, meeting requirements for secure access control. For example, you can grant GaussDB(DWS) users only the permissions for managing a certain type of GaussDB(DWS) resources.
Table 1 lists all the system-defined roles and policies supported by GaussDB(DWS).
Table 1 GaussDB(DWS) system permissions

Role/Policy Name

Description

Category

Dependencies

DWS ReadOnlyAccess

Read-only permissions for GaussDB(DWS). Users granted these permissions can only view GaussDB(DWS) data.

System-defined policy

N/A

DWS FullAccess

Administrator permissions for GaussDB(DWS). Users granted these permissions can perform all operations on GaussDB(DWS).

System-defined policy

N/A

DWS Administrator

Administrator permissions for GaussDB(DWS). Users granted these permissions can perform operations on all GaussDB(DWS) resources.

  • Users granted permissions of the VPC Administrator policy can create VPCs and subnets.
  • Users granted permissions of the Cloud Eye Administrator policy can view monitoring information of data warehouse clusters.

System-defined role

Dependent on the Tenant Guest and Server Administrator policies, which must be assigned in the same project as the DWS Administrator policy.

DWS Database Access

GaussDB(DWS) database access permission. Users with this permission can generate the temporary database user credentials based on IAM users to connect to the database in the data warehouse cluster.

System-defined role

Dependent on the DWS Administrator policy, which must be assigned in the same project as the DWS Database Access policy.

Table 2 lists the common operations supported by each system-defined policy or role of GaussDB(DWS). Choose appropriate policies or roles as required.

  • If you use the EIP for the first time for a project in a region, the system prompts you to create the DWSAccessVPC agency to authorize GaussDB(DWS) to access VPC. After the authorization is successful, GaussDB(DWS) can switch to a healthy VM when the VM bound with the EIP is faulty.
  • By default, only Huawei Cloud accounts or the users with Security Administrator permissions can create agencies. By default, the IAM users in those accounts cannot create agencies. When the users use the EIP, the system displays a message indicating insufficient permissions. Contact a user with the DWS FullAccess permissions to authorize the agency on the current page.
Table 2 Common operations supported by each system-defined policy or role of GaussDB(DWS)

Operation

DWS FullAccess

DWS ReadOnlyAccess

DWS Administrator

DWS Database Access

Creating/Restoring clusters

x

x

Obtaining the cluster list

Obtaining the details of a cluster

Setting automated snapshot policy

x

x

Setting security parameters/parameter groups

x

x

Restarting clusters

x

x

Scaling out clusters

x

x

Resetting passwords

x

x

Applying parameter templates to clusters

x

x

Deleting clusters

x

x

Configuring maintenance windows

x

x

Binding EIPs

x

x

Unbinding EIPs

x

x

Creating DNS domain names

x

x

Releasing DNS domain names

x

x

Modifying DNS domain names

x

x

Creating MRS connections

x

x

Updating MRS connections

x

x

Deleting MRS connections

x

x

Adding/Deleting tags

x

x

Editing tags

x

x

Creating snapshots

x

x

Obtaining the snapshot list

Deleting snapshots

x

x

Copying snapshots

x

x

Creating parameter templates

x

x

Deleting parameter templates

x

x

Modifying parameter templates

x

x