pg_shadow 庻婘滇婺庖劏婋噚垹垄昇拘庖婔婻 PostgreSQL 䬽橸 8.1 幋嬉䔇係䂘臘㔗垄滆䴺庖欔橬湺螄庖 rolcanlogin 䔇蓐謾䔇匂攓㔗
認婻係䂘臘䔇劉庖準躻庯臖臘婉脘赆噸嚖埇臂啹婺垄寙劆埼傴㔗pg_user 滇婔婻婘 pg_shadow 婪噸嚔埇臂䔇蓖商埻滇檪埼傴嘘准潊庖䷺䍘㔗
臘43-45. pg_shadow 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|
| usename | name | pg_authid.rolname | 䫘潙劉 |
| usesysid | oid | pg_authid.oid | 䫘潙䔇 ID |
| usecreatedb | bool | | 䫘潙埇傖录傺昄扞康 |
| usesuper | bool | | 䫘潙滇轙亓䫘潙 |
| usecatupd | bool | | 䫘潙埇傖敘桄係䂘臘㔗剿嘪轙亓䫘潙套悩認婻庖枕婉滇䩘幘婉脘敘桄係䂘臘㔗 |
| passwd | text | | 埼傴(埇脘滇媹凖䔇) |
| valuntil | abstime | | 埼傴崌昽䔇施閘(埻䫘庯埼傴螴臕) |
| useconfig | text[] | | 誊臯施陉䘞埻麟䔇嚔臺䚺䩕 |