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

Question

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

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

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

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 1

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 2

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.

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

Jon.Morisi SSChampion Points: 12846 More actions · Answer 3

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 More actions · Answer 4

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