Subscribe

cannot acquire from DFM - permission denied

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?

Re: cannot acquire from DFM - permission denied

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

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

Re: cannot acquire from DFM - permission denied

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