# Information Schema TABLE\_PRIVILEGES Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `TABLE_PRIVILEGES` table contains table privilege information derived from the [mysql.tables\_priv](https://mariadb.com/docs/server/reference/system-tables/the-mysql-database-tables/mysql-tables_priv-table) grant table.

It has the following columns:

| Column          | Description                                                                                                                                                                    |
| --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| GRANTEE         | In the format user\_name\@host\_name.                                                                                                                                          |
| TABLE\_CATALOG  | Always def.                                                                                                                                                                    |
| TABLE\_SCHEMA   | Database name.                                                                                                                                                                 |
| TABLE\_NAME     | Table name.                                                                                                                                                                    |
| PRIVILEGE\_TYPE | One of SELECT, INSERT, UPDATE, REFERENCES, ALTER, INDEX, DROP or CREATE VIEW.                                                                                                  |
| IS\_GRANTABLE   | Whether the user has the [GRANT OPTION](https://mariadb.com/docs/server/sql-statements/account-management-sql-statements/grant#the-grant-option-privilege) for this privilege. |

Similar information can be accessed with the [SHOW GRANTS](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-grants) statement. See the [GRANT](https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/grant) article for more about privileges.

The table only shows privileges granted on the table level. This differs from the Sys Schema [privileges\_by\_table\_by\_level view](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/privileges_by_table_by_level-sys-schema-view), which shows all privileges, broken down by table.

For a description of the privileges that are shown in this table, see [table privileges](https://mariadb.com/docs/server/sql-statements/account-management-sql-statements/grant#table-privileges).

## See Also

* [sys.privileges\_by\_table\_by\_level](https://mariadb.com/docs/server/reference/system-tables/sys-schema/sys-schema-views/privileges_by_table_by_level-sys-schema-view)

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

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