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 34-32. 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
34.38 for more information.

routine_catalog

sql_identifier

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