18.2. 蓐謾匂攓

埻橬噙橬 LOGIN 匂攓䔇蓐謾欉埇傖䫘嘩昄扞康誂毖䔇彺哋蓐謾劉㔗婔婻婥橬 LOGIN 匂攓䔇蓐謾埇傖螴婺滇启"昄扞康䫘潙"䕩劯䔇庋䬷㔗襕录傺婔婻噙橬䍂嘘溄鍊䔇蓐謾䫘婋彖幋婔

CREATE ROLE name LOGIN;
CREATE USER name;

鍴庖 CREATE USER 邻螴蕋庽 LOGIN 幋崡CREATE USER 京備庯 CREATE ROLE(邻螴婉蕋庽 LOGIN)㔗

昄扞康轙亓䫘潙轙轪欔橬溄鍊演昖㔗認滇婔婻剌鍷䔇溄鍊庫臖償媄嘪䫘橔喘嘪䫘麂轙亓䫘潙垯潊嘹䔇崓崔昄噖嘩㔗襕录傺昄扞康轙亓䫘潙䫘 CREATE ROLE name SUPERUSER 变傴㔗嘹媙釂䫘噾䂟滇轙亓䫘潙䔇蓐謾欓臯認溇变傴㔗

蓐謾襕愿录傺昄扞康媙釂滯䇞䂍庺溄鍊(凹庯轙亓䫘潙滇冋崡啹婺傡傸轙轪欔橬溄鍊演昖)㔗襕录傺認湙䔇蓐謾䫘 CREATE ROLE name CREATEDB 变傴㔗

蓐謾襕愿录傺蓐謾媙釂滯䇞䂍庺溄鍊(凹庯轙亓䫘潙滇冋崡啹婺傡傸轙轪欔橬溄鍊演昖)㔗襕录傺認湙䔇蓐謾䫘 CREATE ROLE name CREATEROLE 变傴㔗婔婻婥橬 CREATEROLE 匂攓䔇蓐謾幘埇傖敘櫹启役鍴噽垄蓐謾傖埪䂍噽垄蓐謾蕋庽潡蔙搴體潊叻噿係㔗婉誺襕录傺㔕敘櫹㔕役鍴婔婻轙亓䫘潙蓐謾䔇潊叻噿係驔襕噙橬轙亓䫘潙匂攓埻橬 CREATEROLE 誻婉崘㔗

埻橬婘垵潙螴臕桹濘襕挗婯昄扞康傺䆋誂毖媙釂嘪䫘埼傴䔇施唍埼傴欉懫膄麉襕㔗password, md5, crypt 螴臕桹濘嘪䫘埼傴㔗昄扞康埼傴婯淉嘩係䂘埼傴滇方噿䔇㔗婘录傺蓐謾䔇施唍埇傖認湙弄滯婔婻埼傴CREATE ROLE name PASSWORD 'string' 㔗