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
Ensure that you have the required permissions to enable metadata extraction.
Grant permissions that allow you to perform the following operations:
•select on pg_catalog.PG_ATTRIBUTE
•select on pg_catalog.PG_CLASS
•select on pg_catalog.PG_CONSTRAINT
•select on pg_catalog.PG_DATABASE
•select on pg_catalog.PG_DESCRIPTION
•select on pg_catalog.PG_LANGUAGE
•select on pg_catalog.PG_NAMESPACE
•select on pg_catalog.PG_PROC
•select on pg_catalog.PG_TYPE
•select on pg_catalog.PG_VIEWS
•select on information_schema.COLUMNS
•select on information_schema.TABLES
•select on pg_catalog.PG_TABLES
•select on pg_catalog.PG_MATVIEWS
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.