Create new PostgreSQL user.
CREATE USER ross WITH PASSWORD '**************';
CREATE USER ross WITH ENCRYPTED PASSWORD '**************';Change user's password
ALTER USER ross WITH PASSWORD '**************';
ALTER USER ross WITH ENCRYPTED PASSWORD '**************';Change owner on a DB
ALTER DATABASE myDatabase OWNER TO ross;Grant all privileges on the new DB
GRANT ALL PRIVILEGES ON DATABASE myDatabase TO ross;Revoke all privileges
REVOKE ALL PRIVILEGES ON DATABASE myDatabase FROM ross;