BUCKVISIONAI 40.0

Founder Access Audit & Partner Review

Founder-only review page for auditing comp accounts, partner codes, redemptions, inactive accounts, expiring trials, and partner access decisions.

Founder Operating System Access Management Access Control Actions

Active Comp Accounts

Active

Review all active lifetime, founder, partner, beta, and temporary comp accounts.

select email, label, access_type, partner_name, active, expires_at, created_at, updated_at
from public.comp_access_accounts
where active = true
order by created_at desc;

Expiring Soon

Expire

Find trial or temporary comp accounts expiring within 30 days.

select email, label, access_type, partner_name, expires_at
from public.comp_access_accounts
where active = true
  and expires_at is not null
  and expires_at <= now() + interval '30 days'
order by expires_at asc;

Inactive / Revoked

Off

Review accounts that were disabled or are no longer active.

select email, label, access_type, partner_name, active, updated_at
from public.comp_access_accounts
where active = false
order by updated_at desc;

Partner Code Usage

Codes

Review codes, usage counts, limits, and expiration dates.

select code, label, access_type, partner_name, active, redemption_count, max_redemptions, expires_at, updated_at
from public.partner_access_codes
order by updated_at desc;

Recent Redemptions

Redeem

Review the latest access-code redemptions by code, email, and name.

select code, email, name, access_type, source, redeemed_at
from public.partner_access_redemptions
order by redeemed_at desc
limit 50;

Recent Email Checks

Events

Review email-based comp access checks and code redemption events.

select email, event_type, access_type, source, notes, created_at
from public.comp_access_events
order by created_at desc
limit 50;

Founder Review Checklist