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?
Asked
Active
Viewed 3,197 times
1
Clawdidr
- 577
- 1
- 8
- 25
-
2`SHOW GRANTS FOR CURRENT_USER` – Aguardientico Aug 15 '13 at 14:40
-
SELECT Host, User FROM mysql.user; possible duplicate http://stackoverflow.com/questions/1623390/mysql-database-permission-question – Anda Iancu Aug 15 '13 at 14:42
-
@Aguardientico Great, it worked. Put it as an answer, so I can accept it. – Clawdidr Aug 15 '13 at 14:44
-
@AndaIancu, this is what I'm getting with your proposal: `Error Code: 1142. SELECT command denied to user 'clawdidr'@'192.168.1.105' for table 'user'` – Clawdidr Aug 15 '13 at 14:46
-
Yes you do not have permission for mysql.user - show grant will do. – Anda Iancu Aug 15 '13 at 14:47
