sql server - Get current user while using SQL Authentication -


we using sql login vehicle issuing permissions, once authenticated through sql, we'd still know active directory name of connected user?

we've tried:

select suser_name() select suser_sname() select suser_sid() select user_name() select user_id() select system_user select session_user select original_login() 

is information still available somewhere?

it appears not possible.

according andrew barber's comment on "get windows user login name sql server":

if logged in sql server user, not logged in windows user; no windows credentials passed @ all; can't information directly


Comments

Popular posts from this blog

php - Submit Form Data without Reloading page -

linux - Rails running on virtual machine in Windows -