Skip to main content ホーム クリエイター autohandai community-skills performing-entitlement-review-with-sailpoint-iiq
performing-entitlement-review-with-sailpoint-iiq Performs entitlement review and access certification campaigns using SailPoint IdentityIQ including manager certifications, targeted entitlement reviews, role-based access validation, SOD violation remediation, and automated revocation workflows. Activates for requests involving access reviews, entitlement certifications, SailPoint IIQ governance, or periodic user access recertification.
インストールへ移動 Skills Marketplace コミュニティが作成したAIスキルを発見・探索
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/autohandai/community-skills --skill performing-entitlement-review-with-sailpoint-iiqコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。
Zipをダウンロード ダウンロード中... name performing-entitlement-review-with-sailpoint-iiq description Performs entitlement review and access certification campaigns using SailPoint IdentityIQ including manager certifications, targeted entitlement reviews, role-based access validation, SOD violation remediation, and automated revocation workflows. Activates for requests involving access reviews, entitlement certifications, SailPoint IIQ governance, or periodic user access recertification.
domain cybersecurity subdomain identity-access-management tags ["SailPoint","IdentityIQ","access-review","entitlement-certification","IGA","access-governance"] version 1.0 author mahipal license Apache-2.0
Performing Entitlement Review with SailPoint IdentityIQ
When to Use
Quarterly or annual access certification campaigns are required for compliance (SOX, HIPAA, PCI-DSS)
Organization needs automated manager-based access reviews for all direct reports
Targeted entitlement reviews are needed for sensitive applications or high-privilege roles
Separation of Duties (SOD) violations must be identified and remediated
Orphaned accounts and excessive entitlements need to be discovered and cleaned up
Audit findings require evidence of periodic access review and remediation tracking
Do not use for real-time access control decisions; IdentityIQ certifications are periodic review processes designed for governance and compliance validation.
Prerequisites
SailPoint IdentityIQ 8.2+ deployed with database backend (Oracle, MySQL, or SQL Server)
Application connectors configured for all in-scope systems (Active Directory, LDAP, databases, SaaS applications)
Identity cubes aggregated with current entitlement data from all connected sources
Email server configured for certification notifications
Manager hierarchy defined in the identity model
Business roles and entitlement glossary populated for reviewer context
Workflow
Step 1: Define Certification Campaign Strategy
Plan the certification scope and reviewer assignments:
import sailpoint.object.*;
import sailpoint.api.*;
import java.util.*;
CertificationSchedule schedule = new CertificationSchedule ();
schedule.setName("Q1-2026-Manager-Access-Review" );
schedule.setDescription("Quarterly manager certification for all active employees" );
schedule.setType(Certification.Type.Manager);
CertificationDefinition certDef = new CertificationDefinition ();
certDef.setName("Q1 Manager Certification"
"cert-admin"
true
true
true
true
Filter
exclusionFilter
=
"type"
"service"
true
7
true
14
"security-governance-team"
30
true
true
Step 2: Configure Targeted Entitlement Certification Set up focused reviews for high-risk applications and privileged entitlements:
import sailpoint.object.*;
import sailpoint.api.*;
CertificationDefinition targetedCert = new CertificationDefinition ();
targetedCert.setName("Privileged Access Targeted Review" );
targetedCert.setType(Certification.Type.ApplicationOwner);
List applicationNames = new ArrayList ();
applicationNames.add("Active Directory" );
applicationNames.add("AWS IAM" );
applicationNames.add("Oracle EBS" );
applicationNames.add("SAP GRC" );
applicationNames.add("CyberArk Vault" );
targetedCert.setApplicationNames(applicationNames);
String entitlementFilter = "entitlement.classification == \"Privileged\" " +
"|| entitlement.riskScore > 800 " +
"|| entitlement.name.contains(\"Admin\") " +
"|| entitlement.name.contains(\"Root\") " +
"|| entitlement.name.contains(\"DBA\")" ;
targetedCert.setEntitlementFilter(entitlementFilter);
targetedCert.setCertifierSelectionType(
CertificationDefinition.CertifierSelectionType.ApplicationOwner
);
targetedCert.setApprovalRequired(true );
targetedCert.setSignOffRequired(true );
targetedCert.setReasonRequired(true );
targetedCert.setCheckSodPolicies(true );
targetedCert.setSodPolicyAction(CertificationDefinition.SodPolicyAction.Flag);
context.saveObject(targetedCert);
context.commitTransaction();
Step 3: Implement SOD Policy Checks Within Certifications Define Separation of Duties policies that flag violations during reviews:
import sailpoint.object.*;
import sailpoint.object.Policy;
Policy sodPolicy = new Policy ();
sodPolicy.setName("Financial SOD - AP/AR Conflict" );
sodPolicy.setType(Policy.TYPE_SOD);
sodPolicy.setDescription("Prevents users from having both Accounts Payable " +
"and Accounts Receivable access simultaneously" );
sodPolicy.setViolationOwner(
context.getObjectByName(Identity.class, "compliance-team" )
);
SODConstraint constraint = new SODConstraint ();
constraint.setName("AP-AR Separation" );
PolicyConstraint leftSide = new PolicyConstraint ();
leftSide.setApplication("SAP ERP" );
leftSide.addEntitlement("SAP_AP_PROCESSOR" );
leftSide.addEntitlement("SAP_AP_APPROVER" );
leftSide.addEntitlement("SAP_AP_ADMIN" );
constraint.setLeftConstraint(leftSide);
PolicyConstraint rightSide = new PolicyConstraint ();
rightSide.setApplication("SAP ERP" );
rightSide.addEntitlement("SAP_AR_PROCESSOR" );
rightSide.addEntitlement("SAP_AR_APPROVER" );
rightSide.addEntitlement("SAP_AR_ADMIN" );
constraint.setRightConstraint(rightSide);
constraint.setViolationSeverity("High" );
constraint.setCompensatingControl("Dual approval required for transactions > $10,000" );
sodPolicy.addConstraint(constraint);
context.saveObject(sodPolicy);
context.commitTransaction();
Step 4: Configure Revocation and Remediation Workflows Automate access removal when certifiers revoke entitlements:
import sailpoint.object.*;
import sailpoint.api.*;
Workflow remediationWorkflow = new Workflow ();
remediationWorkflow.setName("Certification Revocation Workflow" );
remediationWorkflow.setType(Workflow.Type.CertificationRemediation);
Step createPlan = new Step ();
createPlan.setName("Create Revocation Plan" );
createPlan.setScript(
"import sailpoint.object.ProvisioningPlan;\n" +
"import sailpoint.object.ProvisioningPlan.AccountRequest;\n" +
"import sailpoint.object.ProvisioningPlan.AttributeRequest;\n\n" +
"ProvisioningPlan plan = new ProvisioningPlan();\n" +
"plan.setIdentity(identity);\n" +
"AccountRequest acctReq = new AccountRequest();\n" +
"acctReq.setApplication(applicationName);\n" +
"acctReq.setOperation(AccountRequest.Operation.Modify);\n" +
"AttributeRequest attrReq = new AttributeRequest();\n" +
"attrReq.setName(entitlementAttribute);\n" +
"attrReq.setValue(entitlementValue);\n" +
"attrReq.setOperation(ProvisioningPlan.Operation.Remove);\n" +
"acctReq.add(attrReq);\n" +
"plan.add(acctReq);\n" +
"return plan;"
);
Step executeProvisioning = new Step ();
executeProvisioning.setName("Execute Revocation" );
executeProvisioning.setScript(
"import sailpoint.api.Provisioner;\n" +
"Provisioner provisioner = new Provisioner(context);\n" +
"provisioner.setNoTriggers(false);\n" +
"ProvisioningResult result = provisioner.execute(plan);\n" +
"if (result.isCommitted()) {\n" +
" auditEvent(\"Entitlement revoked successfully\", identity, plan);\n" +
"} else {\n" +
" openWorkItem(\"Manual revocation required\", identity, plan);\n" +
"}"
);
Step notification = new Step ();
notification.setName("Send Revocation Notification" );
notification.setScript(
"import sailpoint.tools.EmailTemplate;\n" +
"EmailTemplate template = context.getObjectByName(\n" +
" EmailTemplate.class, \"Access Revocation Notification\");\n" +
"Map args = new HashMap();\n" +
"args.put(\"identityName\", identity.getDisplayName());\n" +
"args.put(\"applicationName\", applicationName);\n" +
"args.put(\"entitlementName\", entitlementValue);\n" +
"args.put(\"certifierName\", certifier.getDisplayName());\n" +
"args.put(\"revocationReason\", decisionReason);\n" +
"context.sendEmailNotification(template, args);"
);
context.saveObject(remediationWorkflow);
context.commitTransaction();
Step 5: Monitor Campaign Progress and Compliance Metrics Track certification completion and generate compliance evidence:
import sailpoint.object.*;
import sailpoint.api.*;
import java.util.*;
QueryOptions qo = new QueryOptions ();
qo.addFilter(Filter.eq("phase" , Certification.Phase.Active));
Iterator certIterator = context.search(Certification.class, qo);
while (certIterator.hasNext()) {
Certification cert = certIterator.next();
System.out.println("Campaign: " + cert.getName());
System.out.println(" Type: " + cert.getType());
System.out.println(" Phase: " + cert.getPhase());
System.out.println(" Due Date: " + cert.getExpiration());
CertificationStats stats = cert.getStatistics();
int totalItems = stats.getTotalEntities();
int completedItems = stats.getCompletedEntities();
int pendingItems = totalItems - completedItems;
double completionPct = (completedItems * 100.0 ) / totalItems;
System.out.println(" Total Items: " + totalItems);
System.out.println(" Completed: " + completedItems + " (" +
String.format("%.1f" , completionPct) + "%)" );
System.out.println(" Pending: " + pendingItems);
int approved = stats.getApprovedCount();
int revoked = stats.getRevokedCount();
int mitigated = stats.getMitigatedCount();
int delegated = stats.getDelegatedCount();
System.out.println(" Decisions:" );
System.out.println(" Approved: " + approved);
System.out.println(" Revoked: " + revoked);
System.out.println(" Mitigated: " + mitigated);
System.out.println(" Delegated: " + delegated);
List certifiers = cert.getCertifiers();
for (Object certObj : certifiers) {
CertificationEntity entity = (CertificationEntity) certObj;
if (!entity.isCompleted() && cert.isOverdue()) {
System.out.println(" [OVERDUE] Certifier: " +
entity.getCertifier().getDisplayName());
}
}
System.out.println();
}
Step 6: Generate Audit Evidence and Reports Export certification results for auditor review:
import sailpoint.object.*;
import sailpoint.api.*;
import sailpoint.tools.Util;
QueryOptions qo = new QueryOptions ();
qo.addFilter(Filter.eq("phase" , Certification.Phase.End));
qo.addFilter(Filter.ge("signed" , Util.stringToDate("2026-01-01" )));
qo.addFilter(Filter.le("signed" , Util.stringToDate("2026-03-31" )));
List results = context.getObjects(Certification.class, qo);
StringBuilder auditReport = new StringBuilder ();
auditReport.append("ACCESS CERTIFICATION AUDIT REPORT\n" );
auditReport.append("Period: Q1 2026\n" );
auditReport.append("Generated: " + new Date () + "\n" );
auditReport.append("=" .repeat(50 ) + "\n\n" );
int totalCampaigns = 0 ;
int totalDecisions = 0 ;
int totalRevocations = 0 ;
for (Certification cert : results) {
totalCampaigns++;
CertificationStats stats = cert.getStatistics();
auditReport.append("Campaign: " + cert.getName() + "\n" );
auditReport.append(" Certifier: " + cert.getCertifiers().size() + " reviewers\n" );
auditReport.append(" Items Reviewed: " + stats.getTotalEntities() + "\n" );
auditReport.append(" Approved: " + stats.getApprovedCount() + "\n" );
auditReport.append(" Revoked: " + stats.getRevokedCount() + "\n" );
auditReport.append(" Completed: " + cert.getSigned() + "\n" );
auditReport.append(" Sign-off: " + (cert.isSignedOff() ? "YES" : "NO" ) + "\n\n" );
totalDecisions += stats.getTotalEntities();
totalRevocations += stats.getRevokedCount();
}
auditReport.append("SUMMARY\n" );
auditReport.append("Total Campaigns: " + totalCampaigns + "\n" );
auditReport.append("Total Decisions: " + totalDecisions + "\n" );
auditReport.append("Total Revocations: " + totalRevocations + "\n" );
auditReport.append("Revocation Rate: " +
String.format("%.1f%%" , (totalRevocations * 100.0 ) / totalDecisions));
System.out.println(auditReport.toString());
Key Concepts Term Definition Certification Campaign An organized review process where designated certifiers validate whether users should retain their current access entitlements across one or more applications Access Review Individual review unit within a campaign where a certifier examines and makes approve/revoke decisions on specific user entitlements Entitlement A specific permission, group membership, role, or access right granted to an identity on a target application Certifier The reviewer responsible for making access decisions, typically a manager, application owner, or data owner Revocation Decision to remove an entitlement from a user, triggering a provisioning request to the target application for access removal SOD Violation Separation of Duties conflict where a user holds entitlements from two or more conflicting access groups that create a segregation risk Remediation Automated or manual process of removing revoked access from target systems following certification decisions
Tools & Systems
SailPoint IdentityIQ : Enterprise identity governance platform providing access certifications, lifecycle management, and compliance reportingIdentityIQ Compliance Manager : Module for running certification campaigns, tracking reviewer progress, and generating compliance evidenceSailPoint REST API : Programmatic interface for automating certification campaigns, querying status, and extracting audit dataIdentityIQ Report Builder : Built-in reporting engine for generating access review statistics, SOD violation summaries, and trend analysis
Common Scenarios
Scenario: SOX Compliance Quarterly Access Review Context : A publicly traded company must demonstrate quarterly access reviews for all financial applications per SOX Section 404. The previous manual review process took 6 weeks and produced inconsistent results.
Define application scope: SAP ERP, Oracle Financials, banking platforms, and treasury systems
Configure manager certifications with 30-day active period for general access review
Create targeted entitlement certifications for privileged financial roles with application owner as certifier
Enable SOD policy checks to flag AP/AR, GL posting/approval, and user admin/transaction conflicts
Configure automatic reminders at 7, 14, and 21 days with escalation to compliance team at day 25
Set default-revoke for items not reviewed by campaign end to enforce completion accountability
Generate signed certification reports with decision audit trail for external auditors
Track revocation completion to ensure all denied access is actually removed from target systems
Not pre-populating entitlement descriptions causes certifiers to approve everything they do not understand
Setting campaigns too short (under 21 days) results in rubber-stamping and low-quality reviews
Not validating that revocations are actually provisioned to target systems (approve on paper, still active in system)
Missing service accounts from review scope when they have access to financial systems
Output Format ACCESS CERTIFICATION CAMPAIGN REPORT
=======================================
Campaign: Q1-2026 Manager Access Review
Type: Manager Certification
Period: 2026-01-15 to 2026-02-14
Status: COMPLETED
COVERAGE
Identities Reviewed: 2,847
Applications In Scope: 34
Total Entitlements: 18,392
DECISION SUMMARY
Approved: 16,841 (91.6%)
Revoked: 1,203 (6.5%)
Mitigated: 198 (1.1%)
Delegated: 150 (0.8%)
REVOCATION STATUS
Provisioned: 1,089 / 1,203 (90.5%)
Pending: 87
Failed: 27 (manual work items created)
SOD VIOLATIONS
Flagged: 43
Remediated: 31
Compensating Controls: 12
CERTIFIER COMPLIANCE
On-Time Completion: 89.3%
Required Escalation: 14 certifiers
Average Review Time: 3.2 minutes per item
SIGN-OFF
Campaign Signed: 2026-02-14 by compliance-admin
Audit Evidence: Exported to /reports/Q1-2026-cert-evidence.pdf
