All Forums Database
leo.issac 184 posts Joined 07/06
01 Oct 2007
DBQL log for Modify User

Does DBQL log SQLs that would modify a user's password? My requirement is such that I should be able to know which user has modified a password for another user.

RGlass 35 posts Joined 09/04
01 Oct 2007

Leo,LastAlterName on DBC.Users should suffice.Tbob

dnoeth 4628 posts Joined 11/04
05 Oct 2007

Query Log doesn't log systemtable accesses and LastAlterName is not only set by "modify password", so the usual way would be enabling Access Log.Dieter

Dieter

You must sign in to leave a comment.