You need to enable JavaScript to run this app.
RDS for PostgreSQL

RDS for PostgreSQL

Copy page
Download PDF
Managing accounts
ModifyDBAccountPrivilege
Copy page
Download PDF
ModifyDBAccountPrivilege
Call the ModifyDBAccountPrivilege API to modify the database account permissions.​
Request type​
Synchronous request.​
Debug​
API Explorer
You can initiate calls online through API Explorer without paying attention to the signature generation process and quickly obtain the call results.
​
Request parameters​
​
Parameter​
Type​
Is it required?​
Example​
Description​
InstanceId​
String​
Yes​
postgres-ca7b7019****​
Instance ID.​
AccountName​
String​
Yes​
testuser​
Account name.​
tip​
Only supports modifying the privileges of a normal account.​
AccountPrivileges​
String​
Yes​
Inherit,Login,CreateRole,CreateDB​
Account privileges information. Values:​
  • Login: login privileges.​
  • Inherit: inherit privileges.​
  • CreateRole: role creation privileges.​
  • CreateDB: create database privileges.​
tip​
  • Modifying privileges for the super account is not supported.​
  • Multiple privileges can be assigned in a single call.​
​
Response parameter​
null​
Sample​
Sample request​
​
POST /?Action=ModifyDBAccountPrivilege&Version=2022-01-01 HTTP/1.1​
Content-Type: application/json​
Host: rds-postgresql.cn-beijing.volcengineapi.com​
X-Date: 20231002T101010Z​
Authorization: HMAC-SHA256 Credential=AKLTN2I0MmFiNzMxNWE5NDgzMzk4MmVjMTVkODlkZTZ****/20211202/cn-beijing/rds_postgresql/request,SignedHeaders=x-date, Signature=71d31fc7bcf990142851c9833c5656391486cda0ae2e0b8ada733b7c6458****​
{​
"InstanceId": "postgres-ca7b7019****",​
"AccountName": "test123",​
"AccountPrivileges": "Inherit,Login,CreateDB"​
}​
​
Sample response​
​
{​
"ResponseMetadata": {​
"RequestId": "20230802164826CE4FCB7FCAD8FBF66470",​
"Action": "ModifyDBAccountPrivilege",​
"Version": "2022-01-01",​
"Service": "rds_postgresql",​
"Region": "cn-beijing"​
},​
"Result": null​
}​
​
Last updated: 2026.03.31 10:45:18