Is there a procedure or function I can use to know what user is running a trigger?
the user being the database user, the application user, the server user...?
The user would be the database user. The one I am interested in is using Window Authentication.
what dbms? in oracle just having the keyword "user" inside the procedure will capture it, then you can insert it somewhere or do something with it.
I am using Microsoft SQL 2000
Does anyone know if there is a function in the MSSQL 2000 that let's me know what user is modifing the table?
The function I was looking for is this:
DECLARE @Username varchar(50)
Set @Username = User_Name()