# 37.15. column\_privileges

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

If a privilege has been granted on an entire table, it will show up in this view as a grant for each column, but only for the privilege types where column granularity is possible: `SELECT`, `INSERT`, `UPDATE`, `REFERENCES`.

#### **Table 37.13. `column_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>table\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database that contains the table that contains the column (always the current database)</p>               |
| <p><code>table\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema that contains the table that contains the column</p>                                                |
| <p><code>table\_name</code> <code>sql\_identifier</code></p><p>Name of the table that contains the column</p>                                                                           |
| <p><code>column\_name</code> <code>sql\_identifier</code></p><p>Name of the column</p>                                                                                                  |
| <p><code>privilege\_type</code> <code>character\_data</code></p><p>Type of the privilege: <code>SELECT</code>, <code>INSERT</code>, <code>UPDATE</code>, or <code>REFERENCES</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>                                                 |