Access rights without select right

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

Answer 1

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.

Answer 2

damn :)

thanks