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

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

+ **`mysql.db:`** Database level privileges

+ For example:
```8
tidb> GRANT ~!@SELECT ON universe.*@!~ TO 'user1'@'localhost';
Query OK, 0 rows affected (0.10 sec)

tidb> SELECT * FROM ~!@mysql.db@!~ WHERE USER='user1' AND HOST='localhost' AND db='universe'\G
*************************** 1. row ***************************
                 Host: localhost
                   DB: universe
                 User: user1
          Select_priv: Y
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          .
          .
          .
           Event_priv: N
         Trigger_priv: N
1 row in set (0.00 sec)
```

-------------------------------------------------------------
For example:
```
tidb> GRANT SELECT ON universe.* TO 'user1'@'localhost';
Query OK, 0 rows affected (0.10 sec)

tidb> SELECT * FROM mysql.db WHERE USER='user1' AND HOST='localhost' AND db='universe'\G
*************************** 1. row ***************************
                 Host: localhost
                   DB: universe
                 User: user1
          Select_priv: Y
          Insert_priv: N
          Update_priv: N
          Delete_priv: N
          Create_priv: N
            Drop_priv: N
           Grant_priv: N
      References_priv: N
           Index_priv: N
           Alter_priv: N
Create_tmp_table_priv: N
     Lock_tables_priv: N
     Create_view_priv: N
       Show_view_priv: N
  Create_routine_priv: N
   Alter_routine_priv: N
         Execute_priv: N
           Event_priv: N
         Trigger_priv: N
1 row in set (0.00 sec)
```
