In my job, I've been granted access to several databases, but not the same degree of liberty for each of them. A few minutes ago, I was attempting to make an UPDATE operation and I got this error message: Error Code: 1142. UPDATE command denied to user 'clawdidr'@'192.168.1.105' for table 'test_table'.
The DB Admin isn't around to give me the information I'm needing, so I've to figure it out by myself. So, the question that arises here is: Is there a way to verify on my own (with a query or something else) which databases or tables am I able to use for a SELECT, INSERT, UPDATE or DELETE operations?
Try with: SHOW GRANTS FOR CURRENT_USER