# 37.39. role\_usage\_grants

The view `role_usage_grants` identifies `USAGE` privileges granted on various kinds of objects where the grantor or grantee is a currently enabled role. Further information can be found under `usage_privileges`. The only effective difference between this view and `usage_privileges` is that this view omits objects that have been made accessible to the current user by way of a grant to `PUBLIC`.

#### **Table 37.37. `role_usage_grants` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                                                           |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>grantor</code> <code>sql\_identifier</code></p><p>The name of the role that granted the privilege</p>                                                                                                 |
| <p><code>grantee</code> <code>sql\_identifier</code></p><p>The name of the role that the privilege was granted to</p>                                                                                          |
| <p><code>object\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the object (always the current database)</p>                                                                |
| <p><code>object\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the object, if applicable, else an empty string</p>                                                            |
| <p><code>object\_name</code> <code>sql\_identifier</code></p><p>Name of the object</p>                                                                                                                         |
| <p><code>object\_type</code> <code>character\_data</code></p><p><code>COLLATION</code> or <code>DOMAIN</code> or <code>FOREIGN DATA WRAPPER</code> or <code>FOREIGN SERVER</code> or <code>SEQUENCE</code></p> |
| <p><code>privilege\_type</code> <code>character\_data</code></p><p>Always <code>USAGE</code></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>                                                                        |