This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Mariadb | restrict check table tablename command for a user

A user with select access is querying a check table tablename. How do I restrict the usage of “check table tablename” command in MySQL

As only the select privilege is required, I am figuring out a way to restrict user from using the command -> check table tablename

Answer Answered by Daniel Black in this comment.

Its not currently possible.

It contains the same level of operations as selecting the contents of the table and hence only needing SELECT_ACL.

What is the reason for restricting CHECK TABLE access?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.