HI Anu,
jet it needs it...How do I know? I had this also...You can find also that otehr had this too:
SCOM HPE OneView DB Login failed ...
https://community.hpe.com/t5/hpe-oneview/scom-hpe-oneview-db-login-failed/td-p/7084445#.Y2owZXbMIoY
YOu can just create login and give it a Read Only access and all the errors from the SQL Logs will be gone.
About the group diagram, please post some more details in a new thread, post what permissions your service accoutn has in the OneView appliance, please go through the HPE OnewView troubleshooting sections and complete the steps there. PLease let me know how it looks.
----------
(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)
Regards
Stoyan Chalakov