November 13, 2014 at 9:58 am
Hi folks,
I have a linked server with security configured to use "Be made using this security context" option, setting a 'usrBlabla' user with high privileges. I know, this is a bad practice, but it's a legacy thing and I need to remove it.
My goal here is to know which users (source) are using the linked server but via DMV's, I just have a usrBlabla login, not the original_login (client side).
There is an easy way to discover this information?
A possible approach is using a Profiler/Extended Events and filter TextData, searching for linked server calls (I think it's works but i wanna avoid tracing).I wanna know if there is another (and better) method...
Version: SQL Server 2008R2 SP2 EE
Thanks!
November 13, 2014 at 10:29 am
well one sure-fire method is to disable the super user and see who complains
Gerald Britton, Pluralsight courses
November 13, 2014 at 11:11 am
Haha. That's my wish (Recoil by fire) but in my particular scenario, it's not a immediate possibility.
My main (and initial) task isn't just remove that user. It's discover the original users...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply