Announcements
Dear all.
I would like to get by SQL script the list of Security changed by Security Configuration tool? My target is to identify the security changed by this tool.
I
tried to check the SysSecConfiguration form table, but, my fault, I didn't find any table in SQL.
Please, could you help me. Thanks in advance.
SysSecUnpublishedObjects is a temporary (InMemory) table, therefore it's not saved in database.
I think that published changes are stored in dbo.Security* tables.
Hi Daniel,
If you select a particular security role, you can click on the audit trail and then compare the changes in permissions. This will show differences for both security configuration changes as well as changes via application updates and customizations. You can check via the AOT which tables are used and how Microsoft is gathering this data.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 445 Super User 2026 Season 1
Subra 407
Martin Dráb 274 Most Valuable Professional
