SECOPS
Daily IAM privilege drift digest from Snowflake
Runs nightly against IAM grant history warehoused in Snowflake, surfaces principals whose privileges drifted beyond their role baseline.
How it runs
The automated pipeline, trigger to output.
- TriggerNightly schedule
- ActionQuery IAM grant historySnowflake
- LogicDiff principals against role baseline
- LogicRank drift by severity
- OutputPost ranked digest to SlackSlack
What it does
This scheduled workflow queries a Snowflake table of historical IAM grants, computes each principal's current effective privileges, and compares them to the expected baseline for that principal's role or team. It produces a ranked list of drift — accounts that accumulated permissions they should not have — and delivers it as a digest for human review.
When to use it
Reach for this when you want continuous least-privilege hygiene rather than emergency revocation. It is the weekly-cleanup companion to real-time detection: it catches slow privilege creep, orphaned grants, and stale access that never tripped an alarm.
How it works
- 1A nightly schedule triggers the run.
- 2A Snowflake query pulls the full grant history and current effective policy set per principal.
- 3A logic step diffs each principal against the role baseline and scores the drift severity.
- 4The findings are ranked, with the riskiest over-privileged accounts first.
- 5A Slack digest posts the top findings with owners and recommended actions; the full table is attached as a CSV for triage.
Set it up
What you configure once, before turning it on.
- 1Connect SnowflakeWarehouses, queries, shares.
- 2Connect SlackChannels, DMs, threads, mentions.
- 3Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
- 4Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
- 5Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.
More SecOps workflows
Post-Revocation Verification and Audit Logging
After a key is revoked, it confirms the old credential actually fails, verifies the replacement works.
Page on-call when a WAF rule mass-blocks legitimate traffic
On demand or every few minutes, it detects a single Cloudflare WAF rule suddenly blocking a broad spread of ASNs and paths (a likely false-positive storm).
PII Content Scan on New Dropbox External Share
When a file gets an external Dropbox link, it reads the file content, uses an AI classifier to detect PII or secrets.
Compile a weekly WAF tuning review with trends to Confluence
Every week an agent rolls up Cloudflare WAF block clusters by rule and ASN, compares them to prior weeks for trend direction.
Sensitive Dropbox Link Owner Remediation Loop
When a newly created Dropbox shared link points to a sensitive file, this workflow DMs the file owner, gives them a deadline to justify or revoke it.
GitLab Push Secret Detection to Block and History Purge
On a GitLab push that contains a detected secret, it revokes the exposed credential, opens a tracking issue with git-history purge instructions.
Run it inside a business
This workflow drops into a full company template. Import the org, and this is one of the playbooks its agents run.
Run this workflow in your colony.
14-day trial. No DevOps. No Sales call. Provisioned in under a minute.