| PostgreSQL 8.1 婺桺桺懼PostgreSQL 婺啘 彽嘩 | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 31. 媇敇昇嚟 | Fast Forward | Next |
蓖商 table_privileges 湺臖欔橬蕋婯嘷嬉䫘潙潡蔙䫌嘷嬉䫘潙蕋庽䔇 婘臘潡蔙蓖商婪䔇溄鍊㔗懟婻臘㔕蕋溄庺㔕埖溄庺䔇䂇劽婔臯㔗 婘䂇婪蕋婯䔇溄鍊婘蓖商 role_table_grants 婺湺庺㔗
Table 31-33. table_privileges 庖枕
| 劉庖 | 昄扞䌂傋 | 柟誄 |
|---|---|---|
| grantor | sql_identifier | 埏庺臖溄鍊毽溄䔇䫘潙劉 |
| grantee | sql_identifier | 冖彄臖溄鍊䔇䫘潙潡蔙䂇䔇劉庖 |
| table_catalog | sql_identifier | 寙劆臖臘䔇昄扞康䔇劉庖攂滇嘷嬉昄扞康 |
| table_schema | sql_identifier | 寙劆臖臘䔇昇嚟劉庖 |
| table_name | sql_identifier | 臘䔇劉庖 |
| privilege_type | character_data | 溄鍊䌂傋 SELECT DELETE INSERT UPDATE REFERENCES RULE 潡蔙 TRIGGER |
| is_grantable | character_data | 套悩溄鍊埇傖蕋婯彆庺彍婺 YES劥彍婺 NO |
| with_hierarchy | character_data | 庫䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
臙濘懟 grantee 幽婉寺彖䫘潙启䂇㔗 套悩嘹橬劯劉䔇䫘潙启䂇闼幽冽婉臯潏傸澇媂濘寺彖垄傸㔗儖準䔇 PostgreSQL 䬽橸埇脘嚔䥕溵䫘潙启䂇劯劉㔗