List all the policies used by specific assertions

Document ID : KB000006153
Last Modified Date : 14/02/2018
Show Technical Document Details

Command to list all the policies which is used by specific assertions.


Please run the this query to list out all policies which is using specific assertion.

select hex(goid), name, version from policy where xml like '%:name%'\G;

Additional Information:

Consider the right ASSERTION name in like phrase, from the above example as name.