<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-applicable-roles-table">
      </a>
      28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080361792">
  </a>
  <p>
   The
   <a class="link" href="information-schema-applicable-roles-table.html" title="28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table">
    <code class="literal">
     APPLICABLE_ROLES
    </code>
   </a>
   table provides
      information about the roles that are applicable for the current
      user.
  </p>
  <p>
   The
   <a class="link" href="information-schema-applicable-roles-table.html" title="28.3.3 The INFORMATION_SCHEMA APPLICABLE_ROLES Table">
    <code class="literal">
     APPLICABLE_ROLES
    </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">
       USER
      </code>
     </p>
     <p>
      The user name part of the current user account.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       HOST
      </code>
     </p>
     <p>
      The host name part of the current user account.
     </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">
       ROLE_NAME
      </code>
     </p>
     <p>
      The user name part of the granted role.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ROLE_HOST
      </code>
     </p>
     <p>
      The host name part of the granted role.
     </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>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_DEFAULT
      </code>
     </p>
     <p>
      <code class="literal">
       YES
      </code>
      or
      <code class="literal">
       NO
      </code>
      , depending on
          whether the role is a default role.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_MANDATORY
      </code>
     </p>
     <p>
      <code class="literal">
       YES
      </code>
      or
      <code class="literal">
       NO
      </code>
      , depending on
          whether the role is mandatory.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
