in our AxDB database there have been a lot of changes made in the security configuration. Therefore the SECURITYOBJECTHISTORY table has grown very large.
As I understand it, this is the table which shows the entire historical record of each security change, the actual XML data of each change, and a ValidFrom and ValidTo date range.
Is it safe to delete data from this table or are there any concerns?
Is it safe to delete from SECURITYOBJECTHISTORY table?
Hi Tino,
I have found this table several times as one of the tables consuming a lot of database space. You can't directly interact with this table as it is not listed in the AOT. I would recommend against direct SQL attempts using scripts. I have looked at some details before and it will be tricky to perform cleanup without full understanding.
I reported this table to Microsoft before as candidate for possible cleanup or archiving.
I would recommend to log a support ticket in case you are over consuming database space and explain you would like to shrink the table.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
152
Share
Report
All responses (
Answers (
