ecp_mssql_revoke_privileges
Revoke specified DML privileges (SELECT, INSERT, UPDATE, DELETE, REFERENCES) from a database user in MSSQL, applying the change schema-wide on dbo to tighten access.
Instructions
Revoke privileges from 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.
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_revoke_privileges"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| confirm | Yes | ||
| db_name | Yes | ||
| privileges | Yes | ||
| db_username | Yes |