capture who executes view

Question

How do you capture who is executing a view? By knowing who executed the view I can implement role based security to manage what they're able to see.

Answer 1

There are a couple of options, and which to use depends on how your application connects to SQL Server.

But to keep things simple: the one you want in the plain-vanilla case is SYSTEM_USER:

   SELECT SYSTEM_USER  

This returns the current login. To confuse matter there is also SESSION_USER, suser_sname() and maybe some which I have forgotten. They are entirely equivalent.

Answer 2

Hi,

In order to catch event you should use "Extended events"

For more information you can start here: Quickstart: Extended events in SQL Server

Answer 3

You can
Continue with us will be the solution