Permissions Management
If you need to assign different permissions to different employees in your enterprise to access your DAS resources, Identity and Access Management (IAM) is a good choice for fine-grained permissions management. IAM provides identity authentication, permissions management, and access control for your cloud resources.
With IAM, you can use your account to create IAM users, and assign permissions to the users to control their access to specific resources. For example, if you need software developers in your enterprise to be able to use DAS but not able to delete DAS resources or perform any high-risk operations, you can create IAM users for the developers and grant them only the permissions required for using DAS resources.
If your account does not require individual IAM users for permissions management, you can skip this section.
IAM is a free service. You only pay for the resources in your account. For more information about IAM, see IAM Service Overview.
DAS Permissions
By default, new IAM users do not have any permissions assigned. You need to add a user to one or more groups and attach permissions policies or roles to these groups. Users then inherit permissions from the groups they belong to and can perform specified operations on cloud services.
DAS is a project-level service deployed in specific physical regions. To assign DAS permissions to a user group, specify projects in specific regions where the permissions will take effect. If you select All projects, the permissions will be granted to the user group in all projects. When accessing DAS, you need to switch to a region where you have been authorized to use this service.
You can grant users permissions by using roles and policies.
- Roles: A type of coarse-grained authorization system that defines permissions related to users responsibilities. Only a limited number of service-level roles are available for authorization. When using roles to grant permissions, you may need to also assign other roles that the permissions depend on. Roles are not ideal for fine-grained authorization and secure access control.
- Policies: A type of fine-grained authorization system that defines permissions required to perform operations on specific cloud resources under certain conditions. Policies are more flexible than roles, and they can ensure more secure access control. For example, you can grant IAM users only permissions for managing a certain type of database resource.
Table 1 lists all the system-defined roles and policies supported by DAS.
Policy Name |
Description |
Type |
Dependency |
---|---|---|---|
DAS Administrator |
DAS administrator, who has full permissions for DAS. |
System-defined role |
This role depends on the Tenant Guest role. The DAS Administrator and Tenant Guest roles must be assigned in the same project. |
DAS FullAccess |
Full permissions for DAS |
System-defined policy |
None |
- DAS depends on other services to implement the management and O&M of databases.
- If you authorize IAM users in fine-grained mode and want to use DAS to manage DB instances, add the DAS FullAccess system policy during authorization.
- On the DAS console, you can view and manage the instances configured in the corresponding services.
By default, users with fine-grained authorization have permissions to view the database login list of Development Tool, delete database login information, and access Intelligent O&M on DAS. The instances visible to these users are the same as those configured in the corresponding services.
Table 2 describes the common operations supported by each system-defined policy or role of DAS. Select the policy or role you need based on the following tables.
Operation |
DAS Administrator |
DAS FullAccess |
---|---|---|
Logging in to a DB instance |
Supported |
Supported |
Adding a login |
Supported |
Supported |
Modifying a login |
Supported |
Supported |
Deleting a DB instance login |
Supported |
Supported |
Viewing the login list in Development Tool |
Supported |
Supported |
Using Intelligent O&M |
Supported |
Supported |
Executing a SQL diagnosis |
Supported |
Supported |
Exporting SQL Explorer data |
Supported |
Supported |
Subscribing to Daily Reports |
Supported |
Supported |
Exporting slow query logs |
Supported |
Supported |
Querying Full SQL Statements |
Supported |
Supported |
Querying the Slow Query Log List |
Supported |
Supported |
Viewing the Intelligent O&M page |
Supported |
Supported |
Querying the Top SQL List |
Supported |
Supported |
Querying the Daily Report List |
Supported |
Supported |
Querying SQL execution plan |
Supported |
Supported |
Operation |
Action |
Remarks |
---|---|---|
Logging in to a DB instance |
das:connections:login |
Configure the permissions required to query other database instances based on the instance type.
|
Obtaining the login information list |
das:connections:list |
Configure the permissions required to query other database instances based on the instance type.
|
Deleting login information |
das:connections:delete |
Configure the permissions required to query other database instances based on the instance type.
|
Adding a login |
das:connections:create |
Configure the permissions required to query other database instances based on the instance type.
|
Modifying a database login |
das:connections:modify |
Configure the permissions required to query other database instances based on the instance type.
|
Changing the payment mode of an instance on Intelligent O&M |
das:clouddba:changePaymentMode |
Configure the permissions required to query other database instances based on the instance type.
|
Killing sessions on Intelligent O&M if necessary |
das:clouddba:deleteProcess |
Configure the permissions required to query other database instances based on the instance type.
|
Executing a SQL diagnosis |
das:clouddba:sqlDiagnosis |
Configure the permissions required to query other database instances based on the instance type.
|
Exporting SQL Explorer data |
das:clouddba:fullSqlExport |
Configure the permissions required to query other database instances based on the instance type.
|
Subscribing to Daily Reports |
das:clouddba:dailyReportsSubscribe |
Configure the permissions required to query other database instances based on the instance type.
|
Exporting slow query logs |
das:clouddba:slowSqlExport |
Configure the permissions required to query other database instances based on the instance type.
|
Querying Full SQL Statements |
das:clouddba:fullSqlList |
Configure the permissions required to query other database instances based on the instance type.
|
Querying the Slow Query Log List |
das:clouddba:slowSqlList |
Configure the permissions required to query other database instances based on the instance type.
|
Viewing the Intelligent O&M page |
das:clouddba:menuList |
NOTE:
This permission is granted by IAM. After this permission is configured, you can view the Intelligent O&M page of DAS. |
Querying the Top SQL List |
das:clouddba:topSqlList |
Configure the permissions required to query other database instances based on the instance type.
|
Querying the Daily Report List |
das:clouddba:dailyReportsList |
Configure the permissions required to query other database instances based on the instance type.
|
Querying SQL execution plan |
das:clouddba:getSqlExecutionPlan |
Configure the permissions required to query other database instances based on the instance type.
|
Policy Name |
Description |
Type |
Dependency |
---|---|---|---|
Tenant Administrator |
Operation permissions:
OBS policies are configured in the Global project. |
System-defined role |
None |
OBS OperateAccess |
Operation permissions: Users with this permission can view buckets, obtain basic bucket information, obtain bucket metadata, view objects, upload objects, download objects, delete objects, and obtain object ACLs. Configure the OBS policies globally. |
System-defined policy |
None |
DAS import and export features require the usage of OBS buckets. You need to obtain required OBS permissions before using these features.
- Typically, it is recommended that you configure the Tenant Administrator policy that allows you to perform operations on OBS resources.
- If you do not want employees to have the permissions for creating and deleting buckets, you can configure the OBS OperateAccess policy for the employees so that they can use the DAS features but cannot create or delete OBS buckets.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot