SQL Database monitoring.

[rupesh]

Hi all,

i want to monitor SQL database security. I want alerts for following

1.User access privilege changes for System local.
2.Database level changes i.e. creation/deletion/modification of
database objects (user, tables, stored procedure, jobs ...etc)

Access Permission setup report for different role holders like SQL
administrator or DBA, sql user. etc.....

Please help me.

Rupesh

[Anders Bengtsson]

Hi rupesh,

I think this post can give you some ideas. http://contoso.se/blog/?p=236


-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se


r> Hi all,
r>
r> i want to monitor SQL database security. I want alerts for following
r>
r> 1.User access privilege changes for System local.
r> 2.Database level changes i.e. creation/deletion/modification of
r> database objects (user, tables, stored procedure, jobs ...etc)
r> Access Permission setup report for different role holders like SQL
r> administrator or DBA, sql user. etc.....
r>
r> Please help me.
r>
r> Rupesh
r>