does sys_audit table captures the records from database view?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 04:30 AM
Hello team,
I want to know if my database view records are getting captured in sys_audit table. can anyone please let me know how to check it.
i also want to know what are all the tables are being captured in sys_audit table.
thank you in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 04:40 AM - edited 03-20-2024 04:42 AM
Hi @Aasrita
I don't think database view records get captured in the audit as it is is not an actual table on the database.
there will be audit checkbox on the dictionary entry of the table. (type = collection)
in general, system tables (starts with sys) are not audited.
Please refer below docs:
Please mark my answer as helpful and correct if helped.
Kind Regards,
Ravi Chandra