ecp_postgres_grant_privileges
Grant privileges to a user on all tables in the public schema and set default privileges for future tables.
Instructions
Grant privileges to a user on a database. Applied per-table (all tables in the public schema) plus default privileges for future tables. Security-sensitive - review carefully before confirming.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"db_name": "<db_name>",
"db_username": "<db_username>",
"privileges": "<privileges>",
"confirm": "<confirm>"
},
"name": "ecp_postgres_grant_privileges"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| confirm | Yes | ||
| db_name | Yes | ||
| privileges | Yes | ||
| db_username | Yes |