ecp_mssql_list_privileges
Lists the five DML privileges a MSSQL user holds on a database, schema-wide (SCHEMA::dbo) not per-table. Use it to audit user access before granting or revoking permissions.
Instructions
List a MSSQL user's privileges 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>"
},
"name": "ecp_mssql_list_privileges"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| db_name | Yes | ||
| db_username | Yes |