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 the following permissions:
•CONNECT permission for the database user account that you use to access the Oracle database.