pg_roles 柊冕螪閞昄扞康蓐謾橬噿媇敇䔇毖埼㔗垄埻滇婔婻 pg_authid 臘䔇噸嚔埇臂鄘彖䔇蓖商檪埼傴庖枕䫘䷺䍘准噙庖㔗
臖蓖商滯䇞䔇滆䴺庖庘北臘䔇 OID 庖枕埇傖䫘庯婯噽垄臘誂毖㔗
臘43-42. pg_roles 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| rolname | name | 蓐謾劉 | |
| rolsuper | bool | 橬轙亓䫘潙溄鍊䔇蓐謾 | |
| rolinherit | bool | 躻媘䂓欪匂婂蓐謾溄鍊䔇蓐謾 | |
| rolcreaterole | bool | 埇傖录傺敘崔蓐謾䔇蓐謾 | |
| rolcreatedb | bool | 埇傖录傺昄扞康䔇蓐謾 | |
| rolcatupdate | bool | 埇傖䕘毖敘桄係䂘臘䔇蓐謾㔗鍴麂認婻庖枕婺䩘劥彍轙亓䫘潙幘婉脘幾認婻庋愙㔗 | |
| rolcanlogin | bool | 埇傖䍂嘘䔇蓐謾幘儌滇臘認婻蓐謾埇傖䂍庽彺哋寡嚔臺螴臕䔇湺臖严㔗 | |
| rolconnlimit | int4 | 凹庯埇傖䍂嘘䔇蓐謾認凪鍊彽庖臖蓐謾噕螩埏蕙䔇橔崓幽埏誂毖昄㔗 -1 臘䴺方鍊彽㔗 | |
| rolpassword | text | 婉滇埼傴(攂滇 ********) | |
| rolvaliduntil | timestamptz | 埼傴崌昽斖橘(埻䫘庯埼傴螴臕)套悩澇橬崌昽橘婺 NULL | |
| rolconfig | text[] | 誊臯施陉䘞埻麟䔇嚔臺䚺䩕 | |
| oid | oid | pg_authid.oid | 蓐謾䔇 ID |