Application Roles
Application roles define what you can do in the MCP Server. There are two types of application roles: Predefined and Custom.
Predefined (Built-in) Application Roles
| Application Role | Description |
|---|---|
| MCP_Administrator | Enables tools to manage the MCP Server. |
| MCP_Operator | By default, this role grants access to all tools in every toolset and all SQL Reports. You can override this default by requiring additional custom roles for access. |
| MCP_User | By default, this role grants access to basic tools of the SQL Reporting toolset and all SQL Reports. You can override this default by requiring additional custom roles for access. |
Custom Application Roles
You can also define custom application roles and then require those roles for specific MCP tools or SQL Reports. To add custom roles, see Creating a Database Tools MCP Server.
The Database Tools MCP toolset enables you to limit access to specific tools and SQL
reports so only users with the required custom application roles can use them. By
default, you must have the MCP_User or the
MCP_Operator roles to access tools and SQL reports.