The metadata extraction process for SQL Server is always read-only. It does not modify data and therefore requires fewer permissions than typical read/write database users.
Required permissions: The user account used for metadata
extraction must have:
CONNECT permission on the target database.
VIEW DEFINITION permission to read database objects and their definitions.
Note:
- The metadata extraction is available only with Advanced Conectivity Bundle (ACB) entitlement.
- These permissions are sufficient for most metadata extraction scenarios. If additional advanced metadata is needed, consult your Database Administrator (DBA) to confirm whether further read-only permissions are required.
- The permission requirements described here are subject to change depending on the database version, configuration, and future updates.