List grants
list_grantsShow who has which privileges on a table and whether they can grant them. Returns grantee, privilege type, grantable flag, and grantor for SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER.
Instructions
List the privileges granted on a table — who may do what to it. Returns a list of objects with grantee, privilege (SELECT / INSERT / UPDATE / DELETE / TRUNCATE / REFERENCES / TRIGGER), grantable (bool — may the grantee regrant), and grantor.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |