# 37.38. role\_udt\_grants

The view `role_udt_grants` is intended to identify `USAGE` privileges granted on user-defined types where the grantor or grantee is a currently enabled role. Further information can be found under `udt_privileges`. The only effective difference between this view and `udt_privileges` is that this view omits objects that have been made accessible to the current user by way of a grant to `PUBLIC`. Since data types do not have real privileges in PostgreSQL, but only an implicit grant to `PUBLIC`, this view is empty.

#### **Table 37.36. `role_udt_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>udt\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the type (always the current database)</p> |
| <p><code>udt\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the type</p>                                  |
| <p><code>udt\_name</code> <code>sql\_identifier</code></p><p>Name of the type</p>                                                          |
| <p><code>privilege\_type</code> <code>character\_data</code></p><p>Always <code>TYPE 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>    |