roles for nurses and doctors CREATE ROLE Nurse; CREATE ROLE Doctor; user for each doctor and nurse CREATE USER NurseMarcus WITHOUT LOGIN; .