> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-schema_privileges-table.md).

# Information Schema SCHEMA\_PRIVILEGES Table

The [Information Schema](/docs/server/reference/system-tables/information-schema.md) `SCHEMA_PRIVILEGES` table contains information about [database privileges](/docs/server/reference/sql-statements/account-management-sql-statements/grant.md#database-privileges).

It contains the following columns:

| Column          | Description                                                         |
| --------------- | ------------------------------------------------------------------- |
| GRANTEE         | Account granted the privilege in the format user\_name\@host\_name. |
| TABLE\_CATALOG  | Always def                                                          |
| TABLE\_SCHEMA   | Database name.                                                      |
| PRIVILEGE\_TYPE | The granted privilege.                                              |
| IS\_GRANTABLE   | Whether the privilege can be granted.                               |

The same information in a different format can be found in the [mysql.db](/docs/server/reference/system-tables/the-mysql-database-tables/mysql-db-table.md) table.

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

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