Accessing the Information Schema
A majority of views in the information schema have row-level security.
Users have permissions to see information schema metadata about the database objects they have permissions to access.
Alternatively, it is possible to grant the SHOW METADATA permission, which grants a user broad access to metadata about all database objects, without requiring read or write permissions to those database objects.
For example, use:
GRANT SHOW METADATA ON *.* to testuser;
GRANT SHOW METADATA ON information_schema.processlist to testuser;
ERROR 1044 ER_DBACCESS_DENIED_ERROR: Access denied for user 'admin'@'%' to database 'information_schema'
Because information schema views are simply views into the internal data structure which holds the information being surfaced in a given view, most information schema views do not have an impact on memory.
To access the
information_, users can either
SELECT data from specific view(s) with a SQL query, or use one of the SHOW Commands which will surface a subset of data from the
information_ depending on the command.
Last modified: November 17, 2022