user names and logins

[Guest_imported]

I need to find out the specific user name or login of the user who is executing a procedure. For example we want to track the updates to a table, so we are creating a trigger on the update of a table, however we need to know who!! is making the change. I have looked into syslogins etc. but cannot seem to find out how to get the specific user who is executing the procedure. Any help would be appreciated.

 

[culshaja]

SELECT user_name() will return te currently logged in user. This could be used in an audit table insert.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[TomSark]

SQL Server 7.0:
User_name() and SUser_Name() will work. The latter returns the login, the former returns the database account name. Usually, they are the name.

You can also use the CURRENT_USER, SESSION_USER, and USER nidalic functions.
Tom Davis
tdavis@sark.com

http://www.sarkdallas.com