topic Re: cannot acquire from DFM - permission denied in Active IQ Unified Manager Discussions https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52299#M10879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How did you create that user? Did you use OC5Setup utility?</P><P></P><P>When setting up WFA for first DFM acquisitions it is highly recommended to refer to Appendix D of the Installation and Setup guide.</P><P>You can find rev 1.7 of said document in the document section in this community.</P><P></P><P>Hope that helps.</P><P></P><P>BR,</P><P>Yaron Haimsohn</P><P>WFA Team</P></BODY></HTML> Mon, 22 Oct 2012 16:11:42 GMT yaronh 2012-10-22T16:11:42Z cannot acquire from DFM - permission denied https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52291#M10874 <HTML><HEAD></HEAD><BODY><P>trying to do initial acquisition from DFM.&nbsp; Created and enabled user on DFM.&nbsp; When trying to acquire, get a SQL error</P><P></P><P>Permission denied - 121&nbsp; you do not have permission to select from "hosts"</P><P></P><P>Did I miss a step?</P></BODY></HTML> Thu, 05 Jun 2025 06:16:58 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52291#M10874 stephen2 2025-06-05T06:16:58Z Re: cannot acquire from DFM - permission denied https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52295#M10877 <HTML><HEAD></HEAD><BODY><P>Use 'hostView" table, not "hosts".&nbsp; You're only allowed to query from the "view" tables. For example:</P><P></P><UL><LI>aggregateView</LI><LI>alarmView</LI><LI>hostView</LI><LI>volumeView</LI><LI>etc...</LI></UL></BODY></HTML> Mon, 22 Oct 2012 15:31:38 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52295#M10877 reide 2012-10-22T15:31:38Z Re: cannot acquire from DFM - permission denied https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52299#M10879 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>How did you create that user? Did you use OC5Setup utility?</P><P></P><P>When setting up WFA for first DFM acquisitions it is highly recommended to refer to Appendix D of the Installation and Setup guide.</P><P>You can find rev 1.7 of said document in the document section in this community.</P><P></P><P>Hope that helps.</P><P></P><P>BR,</P><P>Yaron Haimsohn</P><P>WFA Team</P></BODY></HTML> Mon, 22 Oct 2012 16:11:42 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/cannot-acquire-from-DFM-permission-denied/m-p/52299#M10879 yaronh 2012-10-22T16:11:42Z