Monday, March 26, 2012

Permissions to use SQLProfiler

Hi Friends...
I have some developers that need to use the SQLProfile to analyze some
queries, i dont want to grant them SA priveledges, so, what kind of
permissions needs these users?
Thanks all
Can't do in 2000, I'm afraid. Need sysadmin. In 2005, you can grant permissions to use profiler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Tinchos" <Tinchos@.discussions.microsoft.com> wrote in message
news:EEF2D9D2-3EF4-434D-9AD2-FC26CD2A87CE@.microsoft.com...
> Hi Friends...
> I have some developers that need to use the SQLProfile to analyze some
> queries, i dont want to grant them SA priveledges, so, what kind of
> permissions needs these users?
> Thanks all

No comments:

Post a Comment