XDS Security Policy: How to view Runtime SQL Query
Sohaib Cheema
46,610
User Group Leader
While using security policies, sometimes, it is very much required to see what is happening behind the scene. i.e. runtime quires which are restricting data across whole ax. To know this we can run query on Model Database as following
SELECT PrimaryTableAotName, QueryObjectAOTName,ConstrainedTable, ModeledQueryDebugInfo, ContextType,ContextString,IsEnabled,IsModeled FROM [ModelSecPolRuntimeEx]
This way, we can see actual SQL queries to know exactly, what is happening behind a security policy, which can help in debugging.
*This post is locked for comments