The SHOW GRANT statement displays the permissions associated with the database user accounts.
SHOW GRANTS FOR 'user'
CREATE TABLE testgrant (id int);
CREATE USER user1;
GRANT INSERT,SELECT ON testgrant TO user1;
SHOW GRANTS FOR user1;
Grants for USER1
======================
'GRANT INSERT, SELECT ON testgrant TO USER1'