Reviewing User Access in Clarify via SQL Integration

User access reviews are a critical part of identity governance and compliance. When integrated with SQL-based systems, Clarify (via SoftwareIDM's Identity Panel Suite) provides a secure and automated approach for evaluating who has access to what, and why. This article outlines how Clarify can conduct user access reviews using SQL integration.

SQL-Based Access Review in Clarify

Clarify supports user access reviews by integrating with SQL-based data sources. Through the Identity Panel Suite’s data ingestion framework, access data from systems like Microsoft SQL Server can be imported and transformed into readable identity and entitlement records. These records are then used to create access review campaigns.

Key features include:

• Automated Import of Access Data: Clarify connects to SQL data providers to retrieve user-to-role or user-to-resource relationships.

• Join Rules and Identity Graph: SQL data is joined with identity records using “Join Rules,” which build a unified view of each user across multiple systems.

• Time Traveler and Audit Trails: All changes, access states, and reviews are recorded with historical context for point-in-time validation.

Running Access Reviews with Clarify

Once data is available in Identity Panel, access review campaigns can be initiated directly from Clarify. These reviews can be:

• Manager-based: Reviewers validate whether users under their supervision should maintain access.

• Role-owner-based: Role owners verify that only the appropriate individuals retain access to specific roles or entitlements.

• Criteria-based: Dynamic filters define who and what should be reviewed (e.g., all users with privileged database access).

The campaign outcomes are tracked and stored, and reviewers may approve, revoke, or flag access for follow-up. Optional comments and digital signatures provide added accountability.

Benefits of SQL Integration for Access Reviews

• Centralized oversight: Brings SQL-based entitlements into your unified identity governance platform.

• Audit-ready: Clarify logs all access decisions with reviewer details and timestamps, simplifying audit preparation.

• Efficient compliance: Automates reviews on a recurring schedule to meet internal policies and external regulations.

By enabling SQL-based access data to flow into Clarify, organizations can ensure that access reviews are comprehensive, up to date, and auditable—enhancing both security and compliance posture.