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