HI jack
other 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
Thanks
Naga.Rohitkumar