Audit DDL without any impact to existing server instance.
I given a task for auditing any DDL changes in one particular server instance. There are a few databases on the server and I cannot create any objects or any writes on the server. How can I hit a dictionary table and generate list like Owner, Object Name, Object Type, Last DDL time, Created Time. I plan to run this query from time to time to compare the output. I am a Oracle DBA and have No knowledge of sql server. Please help! Thanks.