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.
Grant the following permissions:
•CONNECT permission for the database user account that you use to access the Oracle database.
• One of the following permissions:
- Grant a predefined SELECT_CATALOG_ROLE role
- Grant permissions that allow you to perform the SELECT operation on the following master repository tables:
▪ SNP_CONNECT
▪ SNP_CONNECT_PROP
▪ SNP_CONTEXT
▪ SNP_LANG_TECHNO
▪ SNP_LSCHEMA
▪ SNP_MTXT
▪ SNP_PSCHEMA
▪ SNP_PSCHEMA_CONT
▪ SNP_TECHNO
- Grant permissions that allow you to perform the SELECT operation on the following work repository tables:
▪ SNP_COLUMN
▪ SNP_FOLDER
▪ SNP_MAPPING
▪ SNP_MODEL
▪ SNP_PACKAGE
▪ SNP_PROJECT
▪ SNP_SCEN
▪ SNP_SCEN_FOLDER
▪ SNP_SCEN_STEP
▪ SNP_SCEN_TASK
▪ SNP_SEQ_SCEN
▪ SNP_SEQUENCE
▪ SNP_STEP
▪ SNP_TABLE
▪ SNP_TRT
▪ SNP_VAR
▪ SNP_VAR_SCEN
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
Grant SELECT permissions for tables and views that you want to profile.
Permissions to run data classification
You don't need any additional permissions to run data classification.
Permissions to run relationship discovery
You don't need any additional permissions to run relationship discovery.
Permissions to run glossary association
You don't need any additional permissions to run glossary association.