Skip to main content
performing-entitlement-review-with-sailpoint-iiq Runs entitlement review and access certification campaigns in SailPoint IdentityIQ, covering manager certifications, targeted entitlement reviews, role-based access validation, segregation-of-duties violation remediation, and automated revocation workflows. Use when performing periodic user access recertification, auditing SailPoint IIQ access governance, or investigating SOD violations.
Ir para a instalação Skills Marketplace Descubra e explore skills de IA criadas pela comunidade.
Ocupações relacionadas SOC
Baseado na classificação ocupacional SOC
Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.
Mostrar detalhes do prompt Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.
npx skills add https://github.com/mukul975/Anthropic-Cybersecurity-Skills --skill performing-entitlement-review-with-sailpoint-iiqO comando permanece em uma só linha. Role horizontalmente para revisá-lo antes de copiar.
Prefere uma cópia local? Baixe os arquivos disponíveis atualmente no SkillsMP.
Baixar Zip Baixando... Explorador de arquivos
4 arquivos Mais deste repositório abusing-dpapi-for-credential-access Extract and decrypt Windows DPAPI-protected secrets (Credential Manager, browser logins/cookies, Wi-Fi credentials, KeePass keys) online or offline using SharpDPAPI, SharpChrome, Mimikatz, or Impacket's dpapi.py, including domain-wide decryption via the DPAPI backup key. Use during authorized red-team credential-access engagements after gaining a foothold or when triaging DPAPI blobs pulled from a host.
abusing-shadow-credentials-for-privesc Take over Active Directory accounts by writing attacker-controlled public keys to msDS-KeyCredentialLink (Shadow Credentials) with pyWhisker, Whisker, or Certipy, then authenticate via PKINIT to recover the target's NT hash without a password reset. Use when BloodHound shows GenericWrite/GenericAll/AddKeyCredentialLink over a target, as a stealthier alternative to ForceChangePassword, during authorized red-team engagements.
acquiring-disk-image-with-dd-and-dcfldd Create forensically sound bit-for-bit disk images with dd or dcfldd on a Linux forensic workstation, preserving evidence integrity through hash verification (MD5/SHA) during acquisition. Use when imaging a suspect drive, USB device, or memory card for investigation, preserving volatile disk evidence during incident response, or producing a verified copy for legal or law-enforcement proceedings before any destructive analysis.
name performing-entitlement-review-with-sailpoint-iiq description Runs entitlement review and access certification campaigns in SailPoint IdentityIQ, covering manager certifications, targeted entitlement reviews, role-based access validation, segregation-of-duties violation remediation, and automated revocation workflows. Use when performing periodic user access recertification, auditing SailPoint IIQ access governance, or investigating SOD violations. 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"] mitre_attack ["T1078","T1110","T1556","T1098"] mitre_f3 {"version":"1.1","tactics":["initial-access","positioning","defense-impairment","resource-development"],"techniques":[{"id":"T1586","name":"Compromise Accounts","tactic":"resource-development","source":"attack"},{"id":"F1033","name":"Insider Access Abuse","tactic":"initial-access","source":"f3"},{"id":"F1005","name":"Account Manipulation","tactic":"positioning","source":"f3"},{"id":"F1005.002","name":"Account Manipulation: Add Authorized User","tactic":"positioning","source":"f3"},{"id":"F1005.007","name":"Account Manipulation: Enable Account Features","tactic":"defense-impairment","source":"f3"}]}
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
