Post reply

Check all the users have running profiler trace permission

  • September 21, 2016 at 11:39 am

    #313811

    Hello,

    Granting the permission to run trace is simple, but if I need to check who all users have executing profiler trace, how to do that by running a simple t sql?

    Thanks.

  • September 21, 2016 at 6:26 pm

    #1902321

    SQL-DBA-01 (9/21/2016)

    Hello,

    Granting the permission to run trace is simple, but if I need to check who all users have executing profiler trace, how to do that by running a simple t sql?

    SELECT u.name, p.permission_name

    FROM sys.server_permissions p

    INNER JOIN sys.server_principals u

    ON p.grantee_principal_id=u.principal_id

    WHERE p.permission_name ='ALTER TRACE'

    Sue

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply