Active IQ Unified Manager Discussions

cannot acquire from DFM - permission denied

stephen2
3,766 Views

trying to do initial acquisition from DFM.  Created and enabled user on DFM.  When trying to acquire, get a SQL error

Permission denied - 121  you do not have permission to select from "hosts"

Did I miss a step?

2 REPLIES 2

reide
3,766 Views

Use 'hostView" table, not "hosts".  You're only allowed to query from the "view" tables. For example:

  • aggregateView
  • alarmView
  • hostView
  • volumeView
  • etc...

yaronh
3,766 Views

Hi,

How did you create that user? Did you use OC5Setup utility?

When setting up WFA for first DFM acquisitions it is highly recommended to refer to Appendix D of the Installation and Setup guide.

You can find rev 1.7 of said document in the document section in this community.

Hope that helps.

BR,

Yaron Haimsohn

WFA Team

Public