PostgreSQL

37.35. `role_routine_grants`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.35. `role_routine_grants`

The view role_routine_grants identifies all privileges granted on functions where the grantor or grantee is a currently enabled role. Further information can be found under routine_privileges. The only effective difference between this view and routine_privileges is that this view omits functions that have been made accessible to the current user by way of a grant to PUBLIC.

Table 37.33. role_routine_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
`specific_catalog`	`sql_identifier`	Name of the database containing the function (always the current database)
`specific_schema`	`sql_identifier`	Name of the schema containing the function
`specific_name`	`sql_identifier`	The “[.quote]#specific name”# of the function. See Section 37.40 for more information.
`routine_catalog`	`sql_identifier`	Name of the database containing the function (always the current database)
`routine_schema`	`sql_identifier`	Name of the schema containing the function
`routine_name`	`sql_identifier`	Name of the function (might be duplicated in case of overloading)
`privilege_type`	`character_data`	Always `EXECUTE` (the only privilege type for functions)
`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

specific_catalog

sql_identifier

Name of the database containing the function (always the current database)

specific_schema

sql_identifier

Name of the schema containing the function

specific_name

sql_identifier

The “[.quote]#specific name”# of the function. See Section 37.40 for more information.

routine_catalog

sql_identifier

Name of the database containing the function (always the current database)

routine_schema

sql_identifier

Name of the schema containing the function

routine_name

sql_identifier

Name of the function (might be duplicated in case of overloading)

privilege_type

character_data

Always EXECUTE (the only privilege type for functions)

is_grantable

yes_or_no

YES if the privilege is grantable, NO if not

Prev	Up	Next
37.34. `role_column_grants`	Home	37.36. `role_table_grants`

37.34. role_column_grants

Home

37.36. role_table_grants

PostgreSQL

37.35. role_routine_grants

37.35. `role_routine_grants`