01 Agustus 2012 17:19
last week we found that, one database user permission has been revoked. Is their any chance to audit this on sql server. I m planning to set this.
Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)
03 Agustus 2012 7:16
The Audit Change Database Owner event class occurs when you use the ALTER AUTHORIZATION statement to change the owner of a database, and the permissions required to do that are checked.
pls visit :
03 Agustus 2012 15:53
Yes this is very much possible. There are variety of way to achieve this task i.e.
- DDL Trigger
- Event Notification
- AUDIT Specification
Here is the sample code of the DDL trigger:
CREATE TABLE AUDIT (EventInfo xml) CREATE TRIGGER ddl_trig_audit_security_events ON ALL DDL_SERVER_SECURITY_EVENTS,DDL_DATABASE_SECURITY_EVENTS FOR CREATE_DATABASE AS INSERT INTO AUDIT (EventInfo) SELECT EVENTDATA()
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)