<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-user-privileges-table">
      </a>
      28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045078052832">
  </a>
  <p>
   The
   <a class="link" href="information-schema-user-privileges-table.html" title="28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table">
    <code class="literal">
     USER_PRIVILEGES
    </code>
   </a>
   table provides
      information about global privileges. It takes its values from the
   <code class="literal">
    mysql.user
   </code>
   system table.
  </p>
  <p>
   The
   <a class="link" href="information-schema-user-privileges-table.html" title="28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table">
    <code class="literal">
     USER_PRIVILEGES
    </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">
       GRANTEE
      </code>
     </p>
     <p>
      The name of the account to which the privilege is granted, in
      <code class="literal">
       '
       <em class="replaceable">
        <code>
         user_name
        </code>
       </em>
       '@'
       <em class="replaceable">
        <code>
         host_name
        </code>
       </em>
       '
      </code>
      format.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog. This value is always
      <code class="literal">
       def
      </code>
      .
     </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 global 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
          global privilege held by the grantee.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       IS_GRANTABLE
      </code>
     </p>
     <p>
      <code class="literal">
       YES
      </code>
      if the user has the
      <a class="link" href="privileges-provided.html#priv_grant-option">
       <code class="literal">
        GRANT OPTION
       </code>
      </a>
      privilege,
      <code class="literal">
       NO
      </code>
      otherwise. The output does not list
      <a class="link" href="privileges-provided.html#priv_grant-option">
       <code class="literal">
        GRANT OPTION
       </code>
      </a>
      as a separate row
          with
      <code class="literal">
       PRIVILEGE_TYPE='GRANT OPTION'
      </code>
      .
     </p>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045078031376">
   </a>
   Notes
  </h4>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a class="link" href="information-schema-user-privileges-table.html" title="28.3.46 The INFORMATION_SCHEMA USER_PRIVILEGES Table">
       <code class="literal">
        USER_PRIVILEGES
       </code>
      </a>
      is a nonstandard
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      table.
     </p>
    </li>
   </ul>
  </div>
  <p>
   The following statements are
   <span class="emphasis">
    <em>
     not
    </em>
   </span>
   equivalent:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa64046256"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>USER_PRIVILEGES

<span class="token keyword">SHOW</span> <span class="token keyword">GRANTS</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span></code></pre>
  </div>
 </div>
 <br/>
</div>
