Permissions for Data and Catalog MCP Tools
Access to tools on the /api/mcp endpoint depends on the authenticated user's Oracle
Analytics Cloud application roles and permissions.
This table explains the default MCP capabilities available to consumers, authors, and administrators.
| Role | Default MCP Capabilities | Workbook Export Through MCP |
|---|---|---|
| BI Service Administrator | Use the full set of data and catalog MCP tools. | Available by default. |
| DV Consumer | Search the catalog and retrieve links to workbooks the user can access. | Requires a custom application role that includes the Schedule Workbooks permission. |
| DV Content Author | Use data and catalog MCP tools, except workbook export. | Requires a custom application role that includes the Schedule Workbooks permission. |
Application roles don't grant unrestricted access to catalog content or data. Users must also have the access required for the requested item and operation. Catalog modifications remain subject to the tool's approval requirements.
Enable Workbook Export
To enable a consumer or author to export workbooks to PDF or PNG through MCP, an administrator must create a custom application role based on the appropriate existing role, grant it the Schedule Workbooks permission, and assign it to the relevant users.
This permission requirement applies to workbook export through the MCP server.
For information about application roles and granting permissions, see About Application Roles and Grant and Revoke Permissions for Application Roles in Configuring Oracle Analytics Cloud.