SECOPS

Daily OAuth Grant Drift Audit

Runs on a schedule to diff today's full set of active OAuth app grants against yesterday's snapshot, then files a Linear issue for every newly appeared or newly elevated grant.

CategorySecOps
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerDaily schedule
  • ActionRead current and prior grant snapshotsPostgreSQLPostgres
  • LogicDiff: new vs. elevated vs. revoked grants
  • ActionDraft justification request per flagged grantOpenAI
  • OutputFile Linear issue per new/elevated grantLinearLinear
  • ActionPersist today's snapshot as baselinePostgreSQLPostgres

What it does

Each morning it pulls the complete inventory of active third-party OAuth grants, compares it to the prior day's stored snapshot, and produces a clean diff: apps that are brand new, apps whose scopes were elevated, and apps that were revoked. Anything new or elevated becomes a tracked Linear issue with the scope detail attached, so review work has an owner and an audit trail.

When to use it

Use this when you want a daily, low-noise paper trail of OAuth changes rather than a per-event firehose, and you triage security follow-ups in Linear.

How it works

  1. 1A scheduled trigger fires once per day.
  2. 2The flow reads the current grant inventory and the previous snapshot from Postgres.
  3. 3A logic step computes the diff and classifies each change as new, elevated, or revoked.
  4. 4An LLM step writes a concise per-app justification request for each new or elevated grant.
  5. 5A Linear issue is created per flagged grant, tagged to the secops triage project.
  6. 6The current inventory is written back to Postgres as the next baseline.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect PostgresAny Postgres URL — query, write, migrate.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect LinearIssues, projects, cycles, triage.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.