CREATE USER new user WITH PASSWORD 'password';
GRANT pg_tencentdb_superuser TO new username;
ALTER USER new user WITH CREATEDB;
ALTER USER new user WITH CREATEROLE;

DROP USER conflicting user;
# If the conflicting user has resource dependencies, run the following statement to modify the owner of the resources first (with a table as an example below):
ALTER TABLE table name OWNER TO new user;