Postgresql
PostgreSQL User Management
Update PostgreSQL username without password
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.
get/Postgresql/rename_user_no_password
Query parameters
newnamestring required
Example:dbuser2
The database user's new name.
Note:
If database prefixing is enabled, this parameter must include the database prefix for the account.
oldnamestring required
Example:dbuser
The database user's current name.
Note:
If database prefixing is enabled, this parameter must include the database prefix for the account.
Response
HTTP Request was successful.
Example response
{
"apiversion": 3,
"func": "rename_user_no_password",
"module": "Postgresql",
"result": {
"status": 1
}
}