# mysql.proxies\_priv Table

1. PARTITION BY SYSTEM\_TIME is not supported for transaction-precise system-versioned tables. Attempting

The `mysql.proxies_priv` table contains information about proxy privileges. The table can be queried and although it is possible to directly update it, it is best to use [GRANT](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) for setting privileges.

This table uses the [Aria](https://mariadb.com/docs/server/server-usage/storage-engines/aria) storage engine.

The `mysql.proxies_priv` table contains the following fields:

| Field         | Type       | Null | Key | Default            | Description |
| ------------- | ---------- | ---- | --- | ------------------ | ----------- |
| Host          | char(60)   | NO   | PRI |                    |             |
| User          | char(80)   | NO   | PRI |                    |             |
| Proxied\_host | char(60)   | NO   | PRI |                    |             |
| Proxied\_user | char(80)   | NO   | PRI |                    |             |
| With\_grant   | tinyint(1) | NO   |     | 0                  |             |
| Grantor       | char(141)  | NO   | MUL |                    |             |
| Timestamp     | timestamp  | NO   |     | CURRENT\_TIMESTAMP |             |

The [Acl\_proxy\_users](https://mariadb.com/docs/server/server-management/variables-and-modes/server-status-variables#acl_proxy_users) status variable indicates how many rows the `mysql.proxies_priv` table contains.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}