CREATE USER

CREATE USER doktor_x WITH PASSWORD 'geheimespasswort1';
CREATE USER schwester_y WITH PASSWORD 'geheimespasswort2';
 
CREATE ROLE klinikpersonal;
GRANT klinikpersonal TO doktor_x, schwester_y;
GRANT CONNECT ON klinik_db TO mitarbeiter;

Verwandt: GRANT, REVOKE