PostgreSQL

PostgreSQL Elephant Logo

36.36. 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 36.34. 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 “[.quote]#specific name”# of the function. See Section 36.41 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

36.35. role_column_grants

Home

36.37. role_table_grants

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group