Hello,
Hope everyone is doing well
I am using .net and oracle/sql in my insurance based project.
I want to add Transactional Logs for auditing purpose, meaning for every imp click_event or action on page , i want to save log.
I can insert that data to new table.
But is there any other way to achieve this?
Thanks in advance
Jignesh KumarPosted Feb 15, 2024, 5:03 AM
Hi Shushant,
You can do using trigger in sql server, please refer this article
https://vladmihalcea.com/sql-server-audit-logging-triggers/
https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/sql-server-triggers-good-scary/