If a user has serverstate permission and don't have show plan permission, will he be able to get plan from cache through dm_exec_query_plan DMF. Also I think he will not be able to get the plan from [set showplan_xml on]
Check out the full sample here: -Marketing-Cloud/target-node-client-samples/tree/master/advanced-atjs-integration-serverstateSee also a SPA demo using serverState here: -Marketing-Cloud/target-node-client-samples/tree/master/react-shopping-cart-demo
ServerState
Download Zip: https://guidifpauka.blogspot.com/?file=2vEM2w
2ff7e9595c
Comments