<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-role-column-grants-table">
      </a>
      28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045078982256">
  </a>
  <p>
   The
   <a class="link" href="information-schema-role-column-grants-table.html" title="28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table">
    <code class="literal">
     ROLE_COLUMN_GRANTS
    </code>
   </a>
   table provides
      information about the column privileges for roles that are
      available to or granted by the currently enabled roles.
  </p>
  <p>
   The
   <a class="link" href="information-schema-role-column-grants-table.html" title="28.3.27 The INFORMATION_SCHEMA ROLE_COLUMN_GRANTS Table">
    <code class="literal">
     ROLE_COLUMN_GRANTS
    </code>
   </a>
   table has
      these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       GRANTOR
      </code>
     </p>
     <p>
      The user name part of the account that granted the role.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GRANTOR_HOST
      </code>
     </p>
     <p>
      The host name part of the account that granted the role.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GRANTEE
      </code>
     </p>
     <p>
      The user name part of the account to which the role is
          granted.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GRANTEE_HOST
      </code>
     </p>
     <p>
      The host name part of the account to which the role is
          granted.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the role applies. This value
          is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the role applies.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_NAME
      </code>
     </p>
     <p>
      The name of the table to which the role applies.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COLUMN_NAME
      </code>
     </p>
     <p>
      The name of the column to which the role applies.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PRIVILEGE_TYPE
      </code>
     </p>
     <p>
      The privilege granted. The value can be any privilege that can
          be granted at the column level; see
      <a class="xref" href="grant.html" title="15.7.1.6 GRANT Statement">
       Section 15.7.1.6, “GRANT Statement”
      </a>
      .
          Each row lists a single privilege, so there is one row per
          column privilege held by the grantee.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_GRANTABLE
      </code>
     </p>
     <p>
      <code class="literal">
       YES
      </code>
      or
      <code class="literal">
       NO
      </code>
      , depending on
          whether the role is grantable to other accounts.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
