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
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
    }
}