corestack_ external_ db_ user_ update
Change a database user.
When to use it
Change a database user's access and, for an external user, its limits and require-TLS. The name and the kind never change: to rename a user or move it between internal and external, remove it and add a new one. Send only what changes; an absent argument stays as it is, and null clears a limit.
Raising a user to read-write lets it change and delete data in the environment's database: ask the person first and send confirm_read_write: "read-write". Lowering it to read-only needs no confirmation.
The change applies within a minute. Open sessions keep their old settings until they reconnect. application, the site's own login, is never changed here.
Ask for it
Using the Corefinity MCP server, call corestack_external_db_user_update with site_id 4211, username oms_reader, max_user_connections 10, max_statement_time 300. (Change a database user.) Tell me what it returned.Inputs
Raising the user to read_write, the text read-write.
External users only, seconds; null clears it.
External users only; null clears it.
External users only.
read_only or read_write.
read_onlyread_writeAt least 1.
The user's name from corestack_external_db_get. Up to 128 characters.
Your assistant fills in a confirmation only after you agree.
Example call
{
"name": "corestack_external_db_user_update",
"arguments": {
"site_id": 4211,
"username": "oms_reader",
"max_user_connections": 10,
"max_statement_time": 300
}
}If it is refused
| Reason | What to do |
|---|---|
confirm_mismatch | Raising the user to read-write without confirm_read_write: "read-write"; nothing changed. |
user_not_found | No user of that name on this environment that can be changed here. |
unchanged | The user already has these settings. |
invalid_arguments | A limit or TLS for an internal user, or a value out of range; fields names each. |
busy | Another change to this environment is applying. |
deleted | The site is deleted (in its grace period). |
provisioning | The site is still being created. |
managed_elsewhere | Another control panel manages this site, so use that control panel for it. This is refused before anything else about the site, as in the Control Panel and the API. Nothing was done. |
tenant_mismatch | The object does not exist or the token may not see it. Check the id. |
scope_required | The token lacks a scope this call needs. Open the link in the answer to add it, then call again. |
pin_refused | The grant is limited to chosen clusters, sites or environments, and this call is outside them. Open the link in the answer to widen it. |
rate_limited | Too many calls. Wait for the number of seconds the answer names. |
temporarily_unavailable | The Control Panel could not answer just now. Nothing was started; try again shortly. |
internal_error | Something went wrong on our side. Quote the trace id to support. |