Skip to main content Accueil Créateurs undermybelt hermes-skills enttlm-review-slpnt-iiq
enttlm-review-slpnt-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.
Aller à l'installation Skills Marketplace Découvrez et explorez les compétences IA créées par la communauté.
Installer avec Codex ou Claude Copiez ce prompt, collez-le dans Codex, Claude ou un autre assistant, puis laissez-le vérifier la page du skill et l'installer pour vous.
Afficher les détails du prompt Une commande directe contourne le prompt de vérification. Examinez la source avant de l'exécuter.
npx skills add https://github.com/Undermybelt/hermes-skills --skill enttlm-review-slpnt-iiqLa commande reste sur une seule ligne. Faites défiler horizontalement pour la vérifier avant de la copier.
Vous préférez une copie locale ? Téléchargez les fichiers actuellement disponibles dans SkillsMP.
Télécharger Zip Téléchargement... Plus depuis ce dépôt Use when retiring old logic, collapsing duplicate owners, removing fallbacks, or touching schema, persistence, or source-of-truth boundaries while deciding whether to delete old paths, retain compatibility, or stop for confirmation.
Use when defining new features, product behavior, UI/component design, architecture choices, contract changes, or ambiguous medium/high-complexity work before implementation.
Use when the user asks for caveman mode, fewer tokens, brief responses, compressed communication, or otherwise explicitly requests a much shorter answer.
Métiers associés SOC
Basé sur la classification professionnelle SOC
Explorateur de fichiers
4 fichiers name enttlm-review-slpnt-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 nist_csf ["PR.AA-01","PR.AA-02","PR.AA-05","PR.AA-06"]
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
