Azure-Samples / Azure-Samples/azure-postgres-mcp-demo

Restricted permissions for the UPDATE queries

Open
#6 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
7
Forks
8
PR merge metrics
No merged PRs in 30d

Description

Hi! I wanted to test update queries and gave permissions for that for my mcp server user:

GRANT INSERT, UPDATE
ON ALL TABLES IN SCHEMA public
TO "azmcp-postgres-server-...";

But looks like permissions is restricted somewhere else as agent says:

1. Privilege/Permission Check
Your user account (azmcp-postgres-server-...) has UPDATE rights on all tables in the public schema, including "folders".
There is no table-level restriction.
2. Error Message
When executing UPDATE folders SET name = 'other_folder' WHERE name = 'MyFolder';
The system returned:
"Only single read-only SELECT statements are allowed."
This is a system/environment restriction, not a SQL or access-control issue.

Can you point me to the right direction where permissions can be changed?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.