Enable all user privileges on PostgreSQL database

This function grants all privileges for a PostgreSQL® database to a database user.

Important:

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

SecurityBasicAuth

Request

query Parameters

database required	string The database's name. Note If database prefixing is enabled, this value must include the database prefix for the account. Example: database=example_database
user required	string The database user's name. Note If database prefixing is enabled, this value must include the database prefix for the account. Example: user=example_dbuser

Responses

200

HTTP Request was successful.

Response Schema: application/json

apiversion	integer The version of the API.
func	string The name of the method called.
module	string The name of the module called.
	object

get/Postgresql/grant_all_privileges

Request samples

CLI
URL
LiveAPI Perl
LiveAPI PHP

uapi --output=jsonpretty \
  --user=username \
  Postgresql \
  grant_all_privileges \
  user='example_dbuser' \
  database='example_database'

Response samples

application/json

{"apiversion": 3,
"func": "grant_all_privileges",
"module": "Postgresql",
"result": {"data": null,
"errors": null,
"messages": null,
"metadata": { },
"status": 1,
"warnings": null
}
}