Reference
willo_db_grant
GRANT or REVOKE table privileges for the site roles (anon, authenticated).
- Act
- Needs approval
- Secret scan
On this page
Grant or revoke table access. ALWAYS needs a person's approval. Runs on the draft backend while the business is drafting (Publish replays it live), otherwise on the LIVE backend; the result's [Backend: …] line says which.
Access
- Token: read + act, and editor access or higher on the business.
- Approval: Always. Every call raises a card a person approves on the dashboard.
- Secret scan: refused if the new content holds a value shaped like an API key or token.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
sql | string | yes | One statement, exactly as written. |