# Example: Privilege Authorization Table - `mysql.user`

__*zz-BGL*__
__*zz-Jeff*__

+ **`mysql.user:`** User account or global level privileges

+ For example:
```
tidb> GRANT ~!@DROP, CREATE ON *.*@!~ TO jack;
Query OK, 0 rows affected (0.17 sec)

tidb> SELECT * FROM ~!@mysql.user@!~ WHERE user='jack'\G
*************************** 1. row ***************************
                  Host: %
                  User: jack
 authentication_string: 
                plugin: mysql_native_password
           Select_priv: N
           Insert_priv: N
           Update_priv: N
           Delete_priv: N
           Create_priv: Y
             Drop_priv: Y
          Process_priv: N
            Grant_priv: N
          .
          .
          .
           Config_priv: N
Create_Tablespace_Priv: N
1 row in set (0.00 sec)
```

-------------------------------------------------------------
For example:
```
tidb> GRANT DROP, CREATE ON *.* TO jack;
Query OK, 0 rows affected (0.17 sec)

tidb> SELECT * FROM mysql.user WHERE user='jack'\G
*************************** 1. row ***************************
                  Host: %
                  User: jack
 authentication_string: 
                plugin: mysql_native_password
           Select_priv: N
           Insert_priv: N
           Update_priv: N
           Delete_priv: N
           Create_priv: Y
             Drop_priv: Y
          Process_priv: N
            Grant_priv: N
       References_priv: N
            Alter_priv: N
          Show_db_priv: N
            Super_priv: N
 Create_tmp_table_priv: N
      Lock_tables_priv: N
          Execute_priv: N
      Create_view_priv: N
        Show_view_priv: N
   Create_routine_priv: N
    Alter_routine_priv: N
            Index_priv: N
      Create_user_priv: N
            Event_priv: N
       Repl_slave_priv: N
      Repl_client_priv: N
          Trigger_priv: N
      Create_role_priv: N
        Drop_role_priv: N
        Account_locked: N
         Shutdown_priv: N
           Reload_priv: N
             FILE_priv: N
           Config_priv: N
Create_Tablespace_Priv: N
1 row in set (0.00 sec)
```