naga.rohitkumar (10/5/2012)
HI jackother than giving sysadmin or using this script
-------------------------------------
Use master
Go
Grant Alter Trace to Login
-------------------------------------
1.if we give bulkadmin and public in server role and ddladmin,db_datareader,db_datawriter in database role also user can acess the sqlserver profiler on a particular database which they are having access
2. iam usingthis process when a application user asking to give access to run trace by sqlserver profiler
3. Is this correct or not ?
4. if it is correct is it safe
Naga,
According to BOL, the only permissions needed to run a trace (Profiler) are ALTER TRACE at the server level.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question