SECOPS
Daily Stale Privileged-Grant Sweep with Auto-Revocation Drafts
Each morning it scans Postgres for privileged grants that have outlived their intended window or sat unused, drafts revocation actions.
How it runs
The automated pipeline, trigger to output.
- TriggerDaily scheduled sweep
- ActionQuery Postgres for stale or unused grantsPostgres
- LogicGroup by owner and rank by exposure
- ActionSend owner confirmation digest in SlackSlack
- OutputWrite confirmed revocations back to PostgresPostgres
What it does
It finds privileged grants that should no longer exist — past their expiry, unused for weeks, or tied to departed users — and walks each toward revocation with an owner confirmation step so nothing critical is cut blindly.
When to use it
Use this to keep standing privileged access from accumulating. It suits teams that store access state in their own database and want a recurring least-privilege cleanup with a human checkpoint before revoking.
How it works
- 1A daily schedule kicks off the sweep.
- 2A Postgres query returns grants past TTL, idle beyond a usage threshold, or owned by deactivated accounts.
- 3A logic step groups findings by resource owner and ranks them by exposure.
- 4Slack sends each owner a digest of their stale grants with Confirm-revoke and Keep buttons and a reason field.
- 5Confirmed revocations write back to Postgres as revoked with the approver and timestamp, closing the audit loop.
Set it up
What you configure once, before turning it on.
- 1Connect PostgresAny Postgres URL — query, write, migrate.
- 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.