Post reply

User has no permission access denied

  • February 16, 2012 at 3:33 am

    #255765

    I m executing long query with joins and dmvs. But it is showing error user has no permission, access denied. But when i execute an individual dmv it is fine. the user has read only permission on the database.

    can any one say how it is possible....

  • February 16, 2012 at 3:52 am

    #1447751

    Please post your query and the actual full error message you are getting

  • March 5, 2012 at 7:09 am

    #1454779

    mohan.bndr (2/16/2012)

    I m executing long query with joins and dmvs. But it is showing error user has no permission, access denied. But when i execute an individual dmv it is fine. the user has read only permission on the database.

    can any one say how it is possible....

    VIEW SERVER STATE permission is required in order to be able to view data from DMVs. Ensure that you have provided this permission to the login that you are using to connect.

    If this doesn't solve your problem, please post the query & the error you are getting.

    Sujeet Singh

  • March 6, 2012 at 12:28 am

    #1455127

    Thanks to all.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply