Determine changes to an account

• LeeFAR

  SSCarpal Tunnel

  Points: 4644

  More actions

  November 9, 2006 at 8:20 am

  #94819

  Does anyone know how I can determine changes made to a specific account on a database?  When an account is changed for a database (added/removed), is this information written to the database's transaction log?

  Thanks for any help!

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 9, 2006 at 2:21 pm

  #670939

  It depends on how you set your audit. You can use the SQL Server Profiler to trrace any change of accounts.