PostgreSQL 8.2.9 Documentation
Prev	Fast Backward	Chapter 32. The Information Schema	Fast Forward	Next

32.25. `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.

Table 32-23. role_routine_grants Columns

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 "specific name" of the function. See Section 32.29 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 (may be duplicated in case of overloading)
`privilege_type`	`character_data`	Always `EXECUTE` (the only privilege type for functions)
`is_grantable`	`character_data`	`YES` if the privilege is grantable, `NO` if not

Prev	Home	Next
`role_column_grants`	Up	`role_table_grants`