I'm currently building a security administrator app and I have a process where when a user's info is updated, the permissions table is also updated.  I send in the UserID that is doing the update into the stored procedure. My question is can the trigger read the "Updated By UserID" param or would I have to have a column in the UserInfo table get updated by the UserID param and then the trigger would get the UserInfo:Updated By UserID column?

Thanks, Lucas