PostgreSQL

36.34. `role_column_grants`
Prev	Up	Chapter 36. The Information Schema	Home	Next

36.34. `role_column_grants`

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.

Table 36.32. role_column_grants Columns

Name Data Type Description

Name	Data Type	Description
`grantor`	`sql_identifier`	Name of the role that granted the privilege
`grantee`	`sql_identifier`	Name of the role that the privilege was granted to
`table_catalog`	`sql_identifier`	Name of the database that contains the table that contains the column (always the current database)
`table_schema`	`sql_identifier`	Name of the schema that contains the table that contains the column
`table_name`	`sql_identifier`	Name of the table that contains the column
`column_name`	`sql_identifier`	Name of the column
`privilege_type`	`character_data`	Type of the privilege: `SELECT`, `INSERT`, `UPDATE`, or `REFERENCES`
`is_grantable`	`yes_or_no`	`YES` if the privilege is grantable, `NO` if not

grantor

sql_identifier

Name of the role that granted the privilege

grantee

sql_identifier

Name of the role that the privilege was granted to

table_catalog

sql_identifier

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

table_schema

sql_identifier

Name of the schema that contains the table that contains the column

table_name

sql_identifier

Name of the table that contains the column

column_name

sql_identifier

Name of the column

privilege_type

character_data

Type of the privilege: SELECT, INSERT, UPDATE, or REFERENCES

is_grantable

yes_or_no

YES if the privilege is grantable, NO if not

Prev	Up	Next
36.33. `referential_constraints`	Home	36.35. `role_routine_grants`

36.33. referential_constraints

Home

36.35. role_routine_grants

PostgreSQL

36.34. role_column_grants

36.34. `role_column_grants`