track changes to only subset of objects in a schema?

LtMandella

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

Rob C

Hi Ken,

You can use filters to force DLM Dashboard only pay attention to the objects that you are interested in. Does that answer your question?

LtMandella

that should do it! thank you Robert!