The Ultimate Guide to High Availability with MariaDB

Comments - Mariadb | restrict check table tablename command for a user

1 month, 2 weeks ago Daniel Black
Re: Mariadb | restrict check table tablename command for a user [Answer]

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?

 
1 month, 2 weeks ago Omkar Wawool
Re: Mariadb | restrict check table tablename command for a user

A user unknowingly fired Check table table name on the prod slave causing lag, to avoid such incidents in future.

 
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.