The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

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?




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.


Yaron Haimsohn

WFA Team


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

  • aggregateView
  • alarmView
  • hostView
  • volumeView
  • etc...
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner