<title><structname>role_table_grants</structname> Columns</title>
<tgroup cols="1">
<thead>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
Column Type
</para>
<para>
Description
</para></entry>
</row>
</thead>
<tbody>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>grantor</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the role that granted the privilege
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>grantee</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the role that the privilege was granted to
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_catalog</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the database that contains the table (always the current database)
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_schema</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the schema that contains the table
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>table_name</structfield> <type>sql_identifier</type>
</para>
<para>
Name of the table
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>privilege_type</structfield> <type>character_data</type>
</para>
<para>
Type of the privilege: <literal>SELECT</literal>,
<literal>INSERT</literal>, <literal>UPDATE</literal>,
<literal>DELETE</literal>, <literal>TRUNCATE</literal>,
<literal>REFERENCES</literal>, or <literal>TRIGGER</literal>
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>is_grantable</structfield> <type>yes_or_no</type>
</para>
<para>
<literal>YES</literal> if the privilege is grantable, <literal>NO</literal> if not
</para></entry>
</row>
<row>
<entry role="catalog_table_entry"><para role="column_definition">
<structfield>with_hierarchy</structfield> <type>yes_or_no</type>
</para>
<para>
In the SQL standard, <literal>WITH HIERARCHY OPTION</literal>
is a separate (sub-)privilege allowing certain operations on
table inheritance hierarchies. In PostgreSQL, this is included
in the <literal>SELECT</literal> privilege, so this column
shows <literal>YES</literal> if the privilege
is <literal>SELECT</literal>, else <literal>NO</literal>.
</para></entry>
</row>
</tbody>
</tgroup>
</table>
</sect1>
<sect1 id="infoschema-role-udt-grants">
<title><literal>role_udt_grants</literal></title>
<para>
The view <literal>role_udt_grants</literal> is intended to identify
<literal>USAGE</literal> privileges granted on user-defined types
where the grantor or grantee is a currently enabled role. Further
information can be found under
<literal>udt_privileges</literal>. The only effective difference
between this view and <literal>udt_privileges</literal> is that
this view omits objects that have been made accessible to the
current user by way of a grant to <literal>PUBLIC</literal>. Since
data types do not have real privileges in PostgreSQL, but only an
implicit grant to <literal>PUBLIC</literal>, this view is empty.
</para>
<table>
<title><structname>role_udt_grants</structname> Columns</title>
<tgroup cols="1">
<thead>
<row>
<entry role="catalog_table_entry"><para