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
Post a Comment