xxxxxxxxxx
postgres=#CREATE ROLE demorole1 WITH LOGIN ENCRYPTED PASSWORD 'password1';
xxxxxxxxxx
CREATE ROLE username NOINHERIT LOGIN PASSWORD password;
xxxxxxxxxx
CREATE ROLE role_name with NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;