Active IQ Unified Manager Discussions

unable to query oci dwh database tables from wfa

Aravind
9,301 Views

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.

 

Untitled.png

 

 

1 ACCEPTED SOLUTION

sinhaa
9,190 Views

This is not any Bug etc.. you need to understand what WFA filters are and how they work. At least bascis. Filter queries run locally on WFA DB. In your query, you are giving DB name which is in OCI DB. Giving the DB(dictionary ) name which is in WFA. It will work.

 

 

 

 

 

If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.

View solution in original post

18 REPLIES 18
Public