To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions to extract metadata
Ensure that you have the required permissions to enable metadata extraction.
Configure the VIEW DEFINITION permission for the user account.
Note:
The
VIEW DEFINITION
permission lists all the schemas from where the user can load metadata.
Grant the following permissions before you configure the catalog source:
•select on sys.all_columns
•select on sys.all_objects
•select on sys.all_parameters
•select on sys.databases
•select on sys.database_principals
•select on sys.foreign_key_columns
•select on sys.indexes
•select on sys.index_columns
•select on sys.partitions
•select on sys.schemas
•select on sys.sql_modules
•select on sys.synonyms
•select on sys.types
•select on sys.tables
•select on sys.table_types
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
To perform data profiling on Microsoft Azure SQL Server, grant SELECT permissions for tables and views that you want to profile.
Permissions to perform data classification
You can perform data classification with the permissions required on the source system to perform metadata extraction.
Permissions to perform relationship discovery
You can perform relationship discovery with the permissions required on the source system to perform metadata extraction.
Permissions to perform glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.