Movatterモバイル変換

ホーム

35.37. `role_table_grants`
Prev	Up	Chapter 35. The Information Schema	Home	Next

35.37. `role_table_grants`#

The viewrole_table_grants identifies all privileges granted on tables or views where the grantor or grantee is a currently enabled role. Further information can be found undertable_privileges. The only effective difference between this view andtable_privileges is that this view omits tables that have been made accessible to the current user by way of a grant toPUBLIC.

Table 35.35. role_table_grants Columns

Column Type Description
`grantorsql_identifier` Name of the role that granted the privilege
`granteesql_identifier` Name of the role that the privilege was granted to
`table_catalogsql_identifier` Name of the database that contains the table (always the current database)
`table_schemasql_identifier` Name of the schema that contains the table
`table_namesql_identifier` Name of the table
`privilege_typecharacter_data` Type of the privilege:`SELECT`,`INSERT`,`UPDATE`,`DELETE`,`TRUNCATE`,`REFERENCES`, or`TRIGGER`
`is_grantableyes_or_no` `YES` if the privilege is grantable,`NO` if not
`with_hierarchyyes_or_no` In the SQL standard,`WITH HIERARCHY OPTION` is a separate (sub-)privilege allowing certain operations on table inheritance hierarchies. In Postgres Pro, this is included in the`SELECT` privilege, so this column shows`YES` if the privilege is`SELECT`, else`NO`.

Column Type

Description

grantorsql_identifier

Name of the role that granted the privilege

granteesql_identifier

Name of the role that the privilege was granted to

table_catalogsql_identifier

Name of the database that contains the table (always the current database)

table_schemasql_identifier

Name of the schema that contains the table

table_namesql_identifier

Name of the table

privilege_typecharacter_data

Type of the privilege:SELECT,INSERT,UPDATE,DELETE,TRUNCATE,REFERENCES, orTRIGGER

is_grantableyes_or_no

YES if the privilege is grantable,NO if not

with_hierarchyyes_or_no

In the SQL standard,WITH HIERARCHY OPTION is a separate (sub-)privilege allowing certain operations on table inheritance hierarchies. In Postgres Pro, this is included in theSELECT privilege, so this column showsYES if the privilege isSELECT, elseNO.

Prev	Up	Next
35.36. `role_routine_grants`	Home	35.38. `role_udt_grants`

pdf epub

By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

ページ先頭

Movatterモバイル変換

35.37. role_table_grants#

35.37. `role_table_grants`#