ecp_mssql_grant_privileges
Grant one or more DML permissions (SELECT, INSERT, UPDATE, DELETE, REFERENCES) to a user on a MSSQL database's default schema, with a confirmation flag required for security.
Instructions
Grant privileges to a user on a database. Note: MSSQL's privilege model here is coarser than MySQL/Postgres - only these 5 DML permissions, applied schema-wide (SCHEMA::dbo), not per-table. 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_mssql_grant_privileges"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| confirm | Yes | ||
| db_name | Yes | ||
| privileges | Yes | ||
| db_username | Yes |