Thanks for the question, Markus.
Asked: June 02, 2022 - 9:46 am UTC
Last updated: June 13, 2022 - 8:52 am UTC
Viewed 1000+ times
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:
Do you have any idea how to get the information when user created or modified comments, synonymms or grants???
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...