Using views with no insert table VS Audit tables
what database is this, make sure to check your DB if it has some inbuilt native solution.
But still if you want to develop Audit part do consider


Insert and Select are difference and independent in relational databases.
Try to trigger only the important columns you want to observer / monitor.
Make sure you have a purge algorithm ready for stale data to keep the tables size in check.
Make sure you properly partition the tables so that the selects are always efficient.