# Example: Privilege Authorization Tables - `mysql.tables_priv`

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

+ **`mysql.tables_priv:`** Table level privileges

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

tidb> SELECT * FROM ~!@mysql.tables_priv@!~ WHERE user='user1' AND host='localhost' AND db='universe' AND table_name='planets'\G
*************************** 1. row ***************************
       Host: localhost
         DB: universe
       User: user1
 Table_name: planets
    Grantor: 
  Timestamp: 2022-09-22 10:10:53
 Table_priv: Select,Update
Column_priv: Select,Update
1 row in set (0.00 sec)

```

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

tidb> SELECT * FROM mysql.tables_priv WHERE user='user1' AND host='localhost' AND db='universe' AND table_name='planets'\G
*************************** 1. row ***************************
       Host: localhost
         DB: universe
       User: user1
 Table_name: planets
    Grantor: 
  Timestamp: 2022-09-22 10:10:53
 Table_priv: Select,Update
Column_priv: Select,Update
1 row in set (0.00 sec)

```