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

32.28. `routine_privileges`

The view routine_privileges identifies all privileges granted to a currently enabled role or by a currently enabled role. There is one row for each combination of function, grantor, and grantee.

Table 32-26. routine_privileges 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_usage_grants`	Up	`routines`