This page in other versions: 8.4 / 9.0 / 9.1 / 9.2 / 9.3  |  Development versions: devel  |  Unsupported versions: 7.4 / 8.0 / 8.1 / 8.2 / 8.3

30.22. role_routine_grants

The view role_routine_grants identifies all privileges granted on functions to a group that the current user is a member of. Further information can be found under routine_privileges.

Table 30-20. role_routine_grants Columns

Name Data Type Description
grantor sql_identifier Name of the user that granted the privilege
grantee sql_identifier Name of the group 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 30.26 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
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group