We recently started using temporal tables for example to retrieve an address as it was at a certain time in the past. However none of the ‘_history’ tables underneath their regular respective temporal tables get any users or roles appointed to them. For example our ‘adres’ table contains 7 roles whereas the ‘adres_history’ table has none.
This is a problem because we want to use this for invoices for example where the invoice retrieves the address as it was on the invoice date. This is vital for invoice retention as is dictated by law. Temporal tables are a great alternative to having to print out all documents to PDF and keeping them in a backup.
I can of course apply these roles manually and that’s probably what I have to do if this is intended behavior. I would like to read some other thoughts on this though before I proceed.
Best answer by Mark Jongeling
View original
