Identifying Database Access Changes

[Skittle]

Is there any way of identifying who has changed a users access to a database on SQL Server?.
A user who could access a database has her authority changed to prevent access and nobody knows which admin user has done it.
I'm not aware of any way of identifying who performed the change but you never know....?




Dazed and confused.

Remember.. 'Depression is just anger without enthusiasum'.

 

[djj55]

Do you have Audit Trace running? For future you can use Audit Trace or a third party (we use Idera SQL Compliance Manager).

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!