track changes to only subset of objects in a schema?

LtMandellaLtMandella Posts: 8
edited January 25, 2016 1:25PM in DLM Dashboard
Our environment is such that various users are daily making ad-hoc changes to objects in dbo schema to meet their job responsibilities, but their account rights also give them ability to change some objects that they shouldn't change, or are changing some objects that they should not be (I did not design this environment or security model).

So our need is not so much to see a flag that indicates when a database's schema has changed but more to track which changes are made, when, and by whom, for specific objects in dbo schema, and be alerted quickly to changes to those specified sql objects.

So is it possible to detect and get alerts to changes for only a specified subset of objects in a particular schema?

thanks,
ken
· Share on Twitter

Comments

Sign In or Register to comment.