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 for metadata extraction
To extract MariaDB metadata, you need account access and permissions to the MariaDB source system.
Verify that the administrator performs the following tasks:
•Creates a user account for the Informatica user to access the MariaDB source system and configures the read permission.
•Configures the SELECT and SHOW VIEW privileges on every database in the source system.
•Grants permissions that allow you to perform the following operations:
- select on information_schema.SCHEMATA
- select on information_schema.TABLES
- select on information_schema.COLUMNS
- select on information_schema.TABLE_CONSTRAINTS
- select on information_schema.KEY_COLUMN_USAGE
- select on information_schema.VIEWS
Permissions to run data profiles
You can run profiles with the permissions required on the source system to perform metadata extraction.
Permissions to run data classification
You can perform data classification with the permissions required on the source system to perform metadata extraction.
Permissions to run glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.