# PostgreSQL User Management

PostgreSQL / User Management

## Create PostgreSQL user

 - [GET /Postgresql/create_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/create_user.md): This function creates a PostgreSQL® database user.

Important:

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

## Delete PostgreSQL user

 - [GET /Postgresql/delete_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/postgresql::delete_user.md): This function deletes a PostgreSQL® user.

Important:

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

## Enable all user privileges on PostgreSQL database

 - [GET /Postgresql/grant_all_privileges](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/grant_all_privileges.md): 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.

## Return PostgreSQL users

 - [GET /Postgresql/list_users](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/postgresql::list_users.md): This function lists an account's PostgreSQL® database users.

Important:

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

## Update PostgreSQL username

 - [GET /Postgresql/rename_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/postgresql::rename_user.md): This function renames a PostgreSQL® database user.

Important:

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

## Update PostgreSQL username without password

 - [GET /Postgresql/rename_user_no_password](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/rename_user_no_password.md): This function renames a PostgreSQL® database user.

Warning:

* If you rename a PostgreSQL user, you must set the password for the database user. This is required because of the md5 hash that PostgreSQL creates to store user passwords.
* We strongly recommend that you use the Postgresql::rename_user function instead of this one.

Important:

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

## Remove PostgreSQL user privileges

 - [GET /Postgresql/revoke_all_privileges](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/revoke_all_privileges.md): This function revokes all privileges for a PostgreSQL® database from a database user.

Important:

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

## Update PostgreSQL user password

 - [GET /Postgresql/set_password](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/set_password.md): This function changes a PostgreSQL® database user's password.

Important:

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

## Update PostgreSQL® privileges

 - [GET /Postgresql/update_privileges](https://api.docs.cpanel.net/specifications/cpanel.openapi/postgresql-user-management/update_privileges.md): 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.