DBQL log for Modify User

Database
Enthusiast

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.

2 REPLIES
Enthusiast

Re: DBQL log for Modify User


Leo,

LastAlterName on DBC.Users should suffice.

Tbob
Senior Apprentice

Re: DBQL log for Modify User

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