Thanks for the question, Markus.
Asked: June 02, 2022 - 9:46 am UTC
Last updated: June 13, 2022 - 8:52 am UTC
Version: 19
Viewed 1000+ times
You Asked
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...
and Connor said...