| PostgreSQL 8.1 婺桺桺懼PostgreSQL 婺啘 彽嘩 | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 31. 媇敇昇嚟 | Fast Forward | Next |
蓖商 column_privileges 湺庺欔橬蕋庽嘷嬉䫘潙䔇庖枕潡蔙嘷嬉䫘潙蕋庽䔇欔橬庖枕㔗 懟婻庖枕㔕毽溄庺启赆蕋庽溄彷䔇䫘潙䂇潊婔臯㔗䂍庽婔婻䂇蕋庽䔇溄鍊婘 role_column_grants 麯湺庺㔗
婘 PostgreSQL 麯嘹埻脘婘昘婻臘婪蕋庽溄鍊 蔯婉滇䋸䆋䔇庖枕㔗啹溴認婻蓖商寙劆启 table_privileges 婔湙䔇媇敇埻滇懟婻劽锗䔇臘麯麵䔇懟婻庖枕鄘橬婔臯嘖滇垄埻襖䕡闼底凹懟庖枕䔇溄鍊侐庥橬懟幬䔇溄鍊SELECTINSERT UPDATEREFERENCES㔗 套悩嘹愿螷嘹䔇庫䫘埇傖锗䫘庯橻準䔇嚔埏锔婩嘪䫘認婻蓖商懫䫘 table_privileges 喘埻襕嘹驔襕蔄荏婪麵䔇溄鍊幋婔㔗
Table 31-5. column_privileges 庖枕
| 劉庖 | 昄扞䌂傋 | 柟誄 |
|---|---|---|
| grantor | sql_identifier | 蕋庽溄鍊䔇䫘潙䔇劉庖 |
| grantee | sql_identifier | 赆蕋庽溄鍊䔇䫘潙潡䂇䔇劉庖 |
| table_catalog | sql_identifier | 寙劆認底庖枕䔇臘欔婘䔇昄扞康劉庖攂滇嘷嬉昄扞康 |
| table_schema | sql_identifier | 寙劆臖庖枕䔇臘欔婘䔇昇嚟䔇劉庖 |
| table_name | sql_identifier | 寙劆臖庖枕䔇臘䔇劉庖 |
| column_name | sql_identifier | 臖庖枕䔇劉庖 |
| privilege_type | character_data | 溄鍊䌂傋SELECTINSERT UPDATE 潡蔙 REFERENCES |
| is_grantable | character_data | 套悩溄鍊埇傖蕋庽婺YES劥彍婺 NO |
臙濘懟庖枕 grantee 婘䫘潙启䂇幋閘澇橬寺彆㔗 套悩嘹橬劯劉䔇䫘潙启䂇闼幽儌冽婉幩澇橬喘媂濘寺彖傡傸㔗 儖準䔇 PostgreSQL 䬽橸埇脘䥕溵䫘潙启䂇劯劉㔗