The metadata extraction process for MySQL is always read-only. It does not modify data and therefore requires fewer permissions than typical users who need read/write access.
Note: The metadata extraction is available
only with Advanced Conectivity Bundle (ACB) entitlement.
-
Required permissions: The user account used for metadata
extraction must have the following privileges on each target
schema containing metadata:
SELECT
SHOW VIEW
TRIGGER
Note:
- The metadata extraction is available only with Advanced Conectivity Bundle (ACB) entitlement.
- These permissions ensure access to all metadata objects within MySQL, including views and triggers. If advanced or custom metadata is needed, consult your Database Administrator (DBA) for additional read-only grants.
- The permission requirements described here are subject to change depending on the database version, configuration, and future updates.