MatrixOne SQL privileges

This page summarizes MatrixOne SQL privileges for quick reference during design, configuration, and troubleshooting.

Reference table

Object level

Common privileges

Notes

Account / role

CREATE USER, CREATE ROLE, GRANT, REVOKE

Manage database identities and role relationships

Database

CREATE, DROP, SHOW

Control database lifecycle and visibility

Table / view

SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCE

Control data access and modification

Other objects

Grant privileges by object type, such as Stage, Function, and Publication

The actual privileges vary by MatrixOne version

How to use this reference

  1. Confirm the product version, workspace, and feature flags in your environment.

  2. Use the table to identify the relevant capability or troubleshooting approach, then follow the corresponding guide to complete the configuration.

  3. Run a minimal test of compatibility, permissions, or limits; do not rely solely on whether an item appears in the interface.

  4. Save the error message, request ID, and time of occurrence to support cross-service troubleshooting.

Product entry and core objects

Item

Current implementation

Page entry

Reference pages do not map to a single runtime entry.

Service contract

Enumerations come from the current frontend registration, Core IAM actions, backend routes, and MatrixOne SQL capabilities; the deployment contract takes precedence over the documentation snapshot.

Core objects

Enum, Feature flag, Permission action, HTTP status, Connector type, Operator

Authorization and limitations

Note

Reference information does not replace the change history. Before you upgrade, also check the release notes and compatibility guidance.