The routine_privileges view provides information about privileges granted on routines.
| Column name | Data type | Description |
|---|---|---|
grantor |
sql_identifier |
The name of the role that granted the privilege. |
grantee |
sql_identifier |
The name of the role to which the privilege was granted. |
specific_catalog |
sql_identifier |
The name of the current database containing the function. |
specific_schema |
sql_identifier |
The name of the schema containing the function. |
specific_name |
sql_identifier |
The “specific name” of the function. |
routine_catalog |
sql_identifier |
The name of the current database containing the function. |
routine_schema |
sql_identifier |
The name of the schema containing the function. |
routine_name |
sql_identifier |
The name of the function. |
privilege_type |
character_data |
The type of the privilege for functions. Always EXECUTE. |
is_grantable |
yes_or_no |
Specifies whether the privilege is grantable (YES) or not (NO). |