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.
The following table lists the schema objects and system tables on which you configure SELECT permissions for the IBM Db2 for LUW database user account:
Schema Objects
System Tables
- Tables
- Views
- Procedures
- Functions
- Databases
- select on syscat.COLUMNS
- select on syscat.FUNCTIONS
- select on syscat.NICKNAMES
- select on syscat.PROCEDURES
- select on syscat.PROCPARMS
- select on syscat.TABLES
- select on syscat.VIEWS
- select on syscat.SCHEMATA
- select on syscat.TABCONST
- select on syscat.REFERENCES
- select on syscat.KEYCOLUSE
Permissions to run data profiles
Ensure that you have the required permissions to run profiles.
To perform data profiling on IBM Db2 for LUW databases, grant the Execute permission on the following objects:
•SYSCAT.ROLEAUTH table
•SYSPROC.AUTH_LIST_GROUPS_FOR_AUTHID built-in table function
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.