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 following permissions:
•select on SYS.FUNCTIONS
•select on SYS.FUNCTION_PARAMETERS
•select on SYS.PROCEDURES
•select on SYS.PROCEDURE_PARAMETERS
•select on SYS.SYNONYMS
•select on SYS.SCHEMAS
•select on SYS.TABLES
•select on SYS.VIEWS
•select on SYS.TABLE_COLUMNS
•select on SYS.VIEW_COLUMNS
•select on SYS.M_TABLES
•select on SYS.CONSTRAINTS
•select on SYS.REFERENTIAL_CONSTRAINTS
•select on _SYS_REPO.ACTIVE_OBJECT
Verify that you configure the following permissions for the username that you use to connect to the database:
•SELECT METADATA on the schemas for which you want to import metadata.
•SELECT on the _SYS_BI and _SYS_BIC system schemas.
To extract metadata from calculation views created in the HANA Deployment Infrastructure (HDI), verify that you have the following permissions:
•SELECT on _SYS_BI.BIMC_SOURCES
•READ permission on the HDI Container schema database
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
To perform data profiling, grant the SELECT permission on the 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 glossary association
You can perform glossary association with the permissions required on the source system to perform metadata extraction.