2015-02-09 07:12 AM - last edited on 2015-02-27 02:27 PM by allison
when i am trying to build a filter i am getting the error as :
Failed getting filter attributes - SELECT command denied to user 'restricted'@'localhost' for table 'volume'
tried to grant permissions but unable to do so, as dwhuser doesnt have permissions.
please help on this.
Solved! SEE THE SOLUTION
2015-02-09 07:19 AM
I think you have something misconfigured in how you are passing your username to MySQL - the error message you are seeing indicates that you are passing "restricted" as the username to mysql
2015-02-09 11:12 PM
i am quite confused why the username in the error is showing as 'restricted', while i am connecting as dwhuser. and moreover dwhuser has the select permissions.
and i am connecting to the db through remote sql client only. i am able to query from every possible way except from wfa.