# 37.41. routine\_privileges

The view `routine_privileges` identifies all privileges granted on functions to a currently enabled role or by a currently enabled role. There is one row for each combination of function, grantor, and grantee.

#### **Table 37.39. `routine_privileges` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                                                                              |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>grantor</code> <code>sql\_identifier</code></p><p>Name of the role that granted the privilege</p>                                                                                                                        |
| <p><code>grantee</code> <code>sql\_identifier</code></p><p>Name of the role that the privilege was granted to</p>                                                                                                                 |
| <p><code>specific\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the function (always the current database)</p>                                                                               |
| <p><code>specific\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the function</p>                                                                                                                |
| <p><code>specific\_name</code> <code>sql\_identifier</code></p><p>The “specific name” of the function. See <a href="https://www.postgresql.org/docs/current/infoschema-routines.html">Section 37.45</a> for more information.</p> |
| <p><code>routine\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the function (always the current database)</p>                                                                                |
| <p><code>routine\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the function</p>                                                                                                                 |
| <p><code>routine\_name</code> <code>sql\_identifier</code></p><p>Name of the function (might be duplicated in case of overloading)</p>                                                                                            |
| <p><code>privilege\_type</code> <code>character\_data</code></p><p>Always <code>EXECUTE</code> (the only privilege type for functions)</p>                                                                                        |
| <p><code>is\_grantable</code> <code>yes\_or\_no</code></p><p><code>YES</code> if the privilege is grantable, <code>NO</code> if not</p>                                                                                           |