I'm sure this has been asked, but search isn't returning the answer.
In a stored procedure, how do I get the value of the user/login that called the stored procedure (name?), assuming I don't already have server_user_id
returns NULL in sql 2008, or at least in my instance of it.
Russell Steen
2010-03-29 15:48:02
mmm... don't have a sql 2008 at hand right now... maybe select original_login()???
opensas
2010-03-29 15:51:56
on sql 2005, these all return the logged userselect suser_name()select suser_sname()select original_login()select system_user
opensas
2010-03-29 15:55:34
Yes, it also seems to work on the other setups I have. it must be something quirky with this one setup.
Russell Steen
2010-03-29 17:10:58