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
Request
- Base URLhttps://cpanel-server.tld:2083/execute
- AuthHTTP basic
Response
HTTP Request was successful.
Example response
{
"apiversion": 3,
"func": "update_privileges",
"module": "Postgresql",
"result": {
"status": 1
}
}Changes
No recorded changes to this operation across all 5 revisions of this API.