Hi,
I'm looking for a query to get all objects modified within the last 24 hours. The data dictionary has views like user_objects with usable columns (created, last_ddl_time, timestamp). But there are also views where I didn't find any information when the objects were modified or created. From my research these are:
- user_tab_comments
- user_col_comments
- user_synonyms
- user_tab_grants
- user_code_grants

Do you have any idea how to get the information when user created or modified comments, synonymms or grants???

Thanks,
markus

P.S. For performance reason I don't want to use complex queries against the audit tables, although there should be the information I'm looking for...