Groups WP Pro stores its core objects across four custom tables: wp_groups_group for group definitions, wp_groups_user_group for user-to-group assignments, wp_groups_capability for the capability catalogue, and wp_groups_group_capability for capability-to-group bindings. The Pro features add nested-group relationships, expiry-aware user assignments, and audit columns for who added or removed each assignment.

The default Groups admin gives separate screens for Groups, Capabilities, and a user-detail view per profile. To answer "who inherits the publish_pages capability through any group," the audit walks wp_groups_capability, joins to wp_groups_group_capability, joins again to wp_groups_user_group, and lists the resulting users. The default UI doesn't expose that walk as a sortable view, so the audit becomes SQL.

SleekView reads all four tables and exposes each as a navigable view, with cross-table joins available so capability inheritance shows up as a column on the user view and group membership shows up as a column on the capability view. Stale assignments (expired but still listed) become a saved filter; bulk cleanup happens through the Groups API for hook-safe writes.

Capabilities granted by group membership are the right abstraction for paid memberships and team-based access control. They're also the abstraction most likely to drift over time. Users gain a group during a campaign, never have it removed, and quietly retain a capability they shouldn't.

Auditing the drift means walking four tables, which is exactly what Groups WP Pro stores but exactly what its default admin doesn't expose as a row-level view. SleekView turns the capability walk into a saved view: per-user inherited-capability counts, per-capability reverse-audit lists, stale-assignment cleanup queues, and bulk group management through the Groups API. Security ops document who can publish pages; site admins bulk-clean expired assignments; auditors export the full inheritance chain for compliance review.

The plugin's data model was always strong enough to support these workflows. SleekView is the operational layer that finally puts the data on one screen.