Skip to main content

Notifications

XDS Security Policy: How to view Runtime SQL Query

Sohaib Cheema Profile Picture 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]



XDSQuery.png

 

This way, we can see actual SQL queries to know exactly, what is happening behind a security policy, which can help in debugging.


Comments

*This post is locked for comments