Updated on 2024-10-28 GMT+08:00

GaussDB Actions

Table 1 DB instance management

Permission

Action

Authorization Scope

API

Creating a DB instance

gaussdb:instance:create

gaussdb:param:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances

Deleting a DB instance

gaussdb:instance:delete

  • Supported:

IAM projects

  • Supported:

Enterprise projects

DELETE /v3/{project_id}/instances/{instance_id}

Querying DB instances

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances

Resetting a database password

gaussdb:instance:modifyPasswd

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/password

Changing a DB instance name

gaussdb:instance:rename

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/instances/{instance_id}/name

Rebooting a DB instance

gaussdb:instance:restart

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/restart

Switching roles of the primary and standby DNs in shards

gaussdb:instance:switchShard

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/switch-shard

Querying the components of a DB instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/components

Changing vCPUs and memory of a DB instance

gaussdb:instance:modifySpec

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/instance/{instance_id}/flavor

Checking whether host load is unbalanced due to a primary/standby switchover

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/balance

Querying solution template settings

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/deployment-form

Querying EIPs bound to a DB instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/public-ips?offset={offset}&limit={limit}

Validating password strength

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/weak-password-verification

Binding or unbinding an EIP

gaussdb:instance:bindPublicIp

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/nodes/{node_id}/public-ip

Querying the SSL certificate download address of a DB instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/ssl-cert/download-link

Querying the instance quotas of a tenant

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/project-quotas?type={type}

Table 2 Parameter configuration

Permission

Action

Authorization Scope

API

Obtaining parameter templates

gaussdb:param:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations?offset={offset}&limit={limit}

Obtaining parameters of a specified DB instance

gaussdb:param:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/configurations

Modifying parameters of a specified DB instance

gaussdb:param:modify

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/instances/{instance_id}/configurations

Creating a parameter template

gaussdb:param:create

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/configurations

Deleting a parameter template

gaussdb:param:delete

  • Supported:

IAM projects

  • Supported:

Enterprise projects

DELETE /v3/{project_id}/configurations/{config_id}

Querying details about a parameter template

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations/{config_id}

Replicating a parameter template

gaussdb:param:create

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/configurations/{config_id}/copy

Resetting a parameter template

gaussdb:param:modify

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/configurations/{config_id}/reset

Obtaining the differences of two parameter templates

gaussdb:param:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/configurations/comparison

Querying instances that a parameter template can be applied to

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations/{config_id}/applicable-instances

Checking whether the parameter template name exists

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations/name-validation?name={name}

Applying a parameter template

gaussdb:param:apply

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/configurations/{config_id}/apply

Querying application records of a parameter template

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations/{config_id}/applied-histories

Querying the change history of a parameter template

gaussdb:param:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/configurations/{config_id}/histories

Table 3 Backup management

Permission

Action

Authorization Scope

API

Configuring an automated backup policy

gaussdb:instance:modifyBackupPolicy

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/instances/{instance_id}/backups/policy

Querying an automated backup policy

gaussdb:backup:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/backups/policy

Querying backups

gaussdb:backup:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/backups?instance_id={instance_id}&backup_id={backup_id}&backup_type={backup_type}&offset={offset}&limit={limit}&begin_time={begin_time}&end_time={end_time}

Creating a manual backup

gaussdb:backup:create

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/backups

Deleting a manual backup

gaussdb:backup:delete

  • Supported:

IAM projects

  • Supported:

Enterprise projects

DELETE /v3/{project_id}/backups/{backup_id}

Querying the restoration time range

gaussdb:backup:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/restore-time?date={date}

Restoring data to a new instance

gaussdb:instance:create

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances

Querying instances that can be used for backups and restorations

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/restorable-instances

Querying information about the original DB instance based on a specific point of time or a backup file

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instance-snapshot?instance_id={instance_id}&backup_id={backup_id}&restore_time={restore_time}

Table 4 DB Engine versions and specifications

Permission

Action

Authorization Scope

API

Querying DB engine versions

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/datastore/versions

Querying database specifications

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/flavors?limit={limit}&offset={offset}&ha_mode={ha_mode}&version={version}&spec_code={spec_code}

Querying DB engines

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/datastores

Querying specifications that a DB instance can be changed to

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/available-flavors

Table 5 Database and account management

Permission

Action

Authorization Scope

API

Creating a database

gaussdb:instance:createDatabase

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/database

Creating a database account

gaussdb:instance:createDatabaseUser

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/db-user

Creating a database schema

gaussdb:instance:createDatabaseSchema

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/schema

Configuring permissions of database accounts

gaussdb:instance:grantDatabasePrivilege

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/db-privilege

Resetting a password for a database account

gaussdb:instance:modifyDatabasePasswd

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/instances/{instance_id}/db-user/password

Querying databases

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/databases

Querying database users

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/db-users

Querying database schemas

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/schemas

Table 6 Tag management

Permission

Action

Authorization Scope

API

Querying tags of a specific instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/tags

Querying tags of a project

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/tags

Querying predefined tags

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/predefined-tags

Adding tags for a DB instance

gaussdb:instance:dealTag

  • Supported:

IAM projects

  • Supported:

Enterprise projects

POST /v3/{project_id}/instances/{instance_id}/tags

Table 7 Storage management

Permission

Action

Authorization Scope

API

Querying the storage usage of a DB instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/instances/{instance_id}/volume-usage

Querying the disk type of a DB instance

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/storage-type?version={version}&ha_mode={ha_mode}

Table 8 Quota management

Permission

Action

Authorization Scope

API

Modifying enterprise project quotas

gaussdb:quota:modify

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/enterprise-projects/quotas

Querying enterprise project quotas

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/enterprise-projects/quotas

Table 9 Task management

Permission

Action

Authorization Scope

API

Obtaining task information

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/jobs?id={id}

Querying tasks

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/tasks

Deleting a task record

gaussdb:instance:deleteTaskRecord

  • Supported:

IAM projects

  • Supported:

Enterprise projects

DELETE /v3/{project_id}/jobs/{job_id}

Table 10 Recycle bin

Permission

Action

Authorization Scope

API

Modifying the recycling policy

gaussdb:instance:setRecyclePolicy

  • Supported:

IAM projects

  • Supported:

Enterprise projects

PUT /v3/{project_id}/recycle-policy

Querying the recycling policy

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/recycle-policy

Querying all DB engine instances in the recycle bin

gaussdb:instance:list

  • Supported:

IAM projects

  • Supported:

Enterprise projects

GET /v3/{project_id}/recycle-instances