?
This document uses PHP Chinese website manual Release
The view role_column_grants identifies all privileges granted on columns where the grantor or grantee is a currently enabled role. Further information can be found under column_privileges. The only effective difference between this view and column_privileges is that this view omits columns that have been made accessible to the current user by way of a grant to public. 視圖 role_column_grants 標(biāo)識(shí)那些在字段上賦予當(dāng)前用戶所屬組的所有權(quán)限。 更多信息可以在 column_privileges中找到。
Table 34-26. role_column_grants 字段
名字 | 數(shù)據(jù)類型 | 描述 |
---|---|---|
grantor | sql_identifier | 被賦予這個(gè)權(quán)限的用戶名稱 |
grantee | sql_identifier | 被賦予這個(gè)權(quán)限的組名稱 |
table_catalog | sql_identifier | 包含此字段的表所在的數(shù)據(jù)庫的名字(總是當(dāng)前數(shù)據(jù)庫) |
table_schema | sql_identifier | 包含該字段的表所在模式的名稱 |
table_name | sql_identifier | 包含該字段的表名稱 |
column_name | sql_identifier | 該字段的名稱 |
privilege_type | character_data | 權(quán)限的類型:SELECT,INSERT, UPDATE,或者REFERENCES |
is_grantable | yes_or_no | 如果權(quán)限是可以賦予的,則為 YES,否則,為 NO |