List all the policies used by specific assertions

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

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

Resolution:

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.