pg_authid 寙劆橬噿昄扞康螴臕湺臖严(蓐謾)䔇媇敇㔗婔婻蓐謾嘷䯄"䫘潙"启"䂇"䔇楗媕㔗婔婻䫘潙垂鍙婪埻滇婔婻螆䘞庖 rolcanlogin 湺媖䔇蓐謾㔗傂嘘蓐謾(婉䞇螆䘞庖 rolcanlogin)湺媖)鄘埇傖橬噽垄蓐謾啔婺潊叻埗黙 pg_auth_members
啹婺認婻係䂘臘寙劆埼傴欔傖垄婉滇噸噌埇臂䔇㔗pg_roles 滇婔婻婘 pg_authid 婪䔇蓖商埻滇檪埼傴嘘准潊庖䷺䍘㔗
䆹18 寙劆䫘潙启溄鍊䞇䊖䔇臥䂖媇敇㔗
啹婺䫘潙湺臖滇镖䆴评啘䔇pg_authid 婘婔婻镖䆴麯欔橬䔇昄扞康幋閘滇噌庆䔇懟婻镖䆴埻橬婔婻 pg_authid 拙蘺蔯婉滇懟婻昄扞康婔婻㔗
臘43-8. pg_authid 庖枕
| 劉庖 | 䌂傋 | 柟誄 | |
|---|---|---|---|
| rolname | name | 蓐謾劉䓄 | |
| rolsuper | bool | 蓐謾拖橬轙亓䫘潙溄鍊 | |
| rolinherit | bool | 蓐謾躻媘䂓欪噽欔匂蓐謾䔇溄鍊 | |
| rolcreaterole | bool | 蓐謾埇傖录傺敘崔蓐謾 | |
| rolcreatedb | bool | 蓐謾埇傖录傺昄扞康 | |
| rolcatupdate | bool | 蓐謾埇傖䕘毖敘桄係䂘臘㔗套悩澇橬螆䘞認婻庖枕婺䩘剿嘪轙亓䫘潙幘婉脘認幽啔㔗 | |
| rolcanlogin | bool | 蓐謾埇傖䍂嘘幘儌滇臘認婻蓐謾埇傖䂍庽嚔臺螴臕湺臖严㔗 | |
| rolconnlimit | int4 | 凹庯埇傖䍂嘘䔇蓐謾鍊彽噽橔崓幽埏誂毖昄麟㔗-1 臘䴺澇橬鍊彽㔗 | |
| rolpassword | text | 埼傴(埇脘滇媹凖䔇)套悩澇橬彍婺 NULL | |
| rolvaliduntil | timestamptz | 埼傴崌昽施閘(埻䫘庯埼傴螴臕)套悩澇橬崌昽橘彍婺 NULL | |
| rolconfig | text[] | 誊臯施陉䘞埻麟䔇嚔臺䚺䩕 |