User shouldn't be able to run but can in production

  • Grant Fritchey

    SSC Guru

    Points: 396709

    Jeff Moden (2/25/2016)


    Markus (2/25/2016)


    Is it possible to run profiler and see what userid is connecting and running that query?

    Agreed. Setting it up to find the name of the proc in the "text data" using RPC Completed and Batch Completed will be mostly benign for resource usage, as well.

    This is 2014, extended events, please.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Jeff Moden

    SSC Guru

    Points: 997132

    Grant Fritchey (2/25/2016)


    Jeff Moden (2/25/2016)


    Markus (2/25/2016)


    Is it possible to run profiler and see what userid is connecting and running that query?

    Agreed. Setting it up to find the name of the proc in the "text data" using RPC Completed and Batch Completed will be mostly benign for resource usage, as well.

    This is 2014, extended events, please.

    Oh hell no. 😀 That uses XML. :sick:

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jon.Morisi

    SSChampion

    Points: 12846

    Extended Events = NBAN (Node by agonizing node)?

    Seriously though, this is the best article I've seen. Anyone got one better? [EDIT: ...for pre-"view target data..."]

    https://www.brentozar.com/archive/2015/01/query-extended-events-target-xml/[/url]

  • crmitchell

    SSCarpal Tunnel

    Points: 4557

    His AD account isn't a local admin for the windows box by any chance?

Viewing 4 posts - 16 through 19 (of 19 total)

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