• 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