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