v1

latestOpenAPI 3.0.2cPanel License2026-08-06657427.1 MB
Postgresql
PostgreSQL User Management

Update PostgreSQL® privileges

This function synchronizes PostgreSQL® database user privileges on an account.

Some versions of PostgreSQL are ANSI SQL-92 compliant and do not support recursive grants, wildcard grants, or future grants. If you use phpPgAdmin, or manually create new tables, and you want multiple PostgreSQL users to access your PostgreSQL tables, you may either call this API function or click Synchronize Grants in the PostgreSQL Databases interface (Home >> Databases >> PostgreSQL Databases) after you add a table.

Important:

When you disable the PostgreSQL role, the system disables this function.

get/Postgresql/update_privileges

Response

HTTP Request was successful.

apiversioninteger

The version of the API.

funcstring

The name of the method called.

modulestring

The name of the module called.

Example response

{
  "apiversion": 3,
  "func": "update_privileges",
  "module": "Postgresql",
  "result": {
    "status": 1
  }
}