locked
Access rights without select right RRS feed

  • Question

  • Hi there,

    I was asked to check all databases indexes usage through DMV. I have access to DMVs, but I have not access to all DBs. Is there any way how to get to DMV index,table statistics without SELECT access to DB? there are some confident data and I have not permission to see them.

    thanks a lot

    Friday, September 7, 2012 12:51 PM

Answers

  • Hi Volyn,

    There is no way. You need SELECT permission on the database to complete this task.


    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Basit Farooq Friday, September 7, 2012 1:44 PM
    • Marked as answer by volyn Friday, September 7, 2012 4:37 PM
    Friday, September 7, 2012 1:44 PM

All replies

  • Hi Volyn,

    There is no way. You need SELECT permission on the database to complete this task.


    Regards,

    Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)

    http://basitaalishan.com

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

    • Proposed as answer by Basit Farooq Friday, September 7, 2012 1:44 PM
    • Marked as answer by volyn Friday, September 7, 2012 4:37 PM
    Friday, September 7, 2012 1:44 PM
  • damn :)

    thanks

    Friday, September 7, 2012 4:37 PM