• Use the below query:

    Use [Databasename]

    go

    Grant SELECT ON Viewname TO dhii;