| PostgreSQL 8.1 婺桺桺懼PostgreSQL 婺啘 彽嘩 | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 31. 媇敇昇嚟 | Fast Forward | Next |
蓖商 routine_privileges 湺臖婘庘昄婪欔橬蕋庽嘷嬉䫘潙潡蔙䫌嘷嬉䫘潙蕋庽䔇溄鍊㔗 懟婻庘昄毽溄庺启溄鍊毖埖庺䔇䂇劽鄘橬婔臯㔗䂍䂇蕋庽䔇溄鍊婘蓖商 role_routine_grants 麯湺庺㔗
Table 31-23. routine_privileges 庖枕
| 劉庖 | 昄扞䌂傋 | 柟誄 |
|---|---|---|
| grantor | sql_identifier | 蕋庽溄鍊䔇䫘潙䔇劉庖 |
| grantee | sql_identifier | 赆毽庽溄鍊䔇䫘潙潡蔙䂇䔇劉庖 |
| specific_catalog | sql_identifier | 寙劆臖庘昄䔇昄扞康劉庖攂滇嘷嬉昄扞康 |
| specific_schema | sql_identifier | 寙劆臖庘昄䔇昇嚟䔇劉庖 |
| specific_name | sql_identifier | 庘昄"噙嘷䔇劉庖"㔗埗黙 Section 31.26 诙埡敘崔媇敇㔗 |
| routine_catalog | sql_identifier | 寙劆臖庘昄䔇昄扞康䔇劉庖攂滇嘷嬉昄扞康 |
| routine_schema | sql_identifier | 寙劆臖庘昄䔇昇嚟䔇劉庖 |
| routine_name | sql_identifier | 庘昄䔇劉庖埇脘嚔啹崓償喍潡蔙麉蘘蔯麉崉 |
| privilege_type | character_data | 攂滇 EXECUTE 䫘庯庘昄䔇嫇婔䔇溄鍊䌂傋 |
| is_grantable | character_data | 套悩溄鍊滇埇蕋庽䔇彍婺 YES套悩婉滇婺 NO |
臙濘懟庖枕 grantee 幽婉寺彖䫘潙启䂇㔗 套悩嘹橬劯劉䔇䫘潙启䂇闼幽滇澇橬媂濘寺彖垄傸䔇㔗儖準䬽橸䔇 PostgreSQL 冽埇脘儖䥕溵䫘潙启䂇劯劉㔗