Oracle as the Source Database Type

DBMS_METADATA

Permission to retrieve metadata from the Oracle database dictionary. This permission is used to obtain the DDL of schema objects.

DBA permission needs to be granted.

1. Create a user.

   CREATE USER user IDENTIFIED BY password;

2. Grant the login permission to the user.

   GRANT CONNECT TO user;

3. Grant the DBA permission to the user.

   GRANT DBA TO user;

Dynamic View

Permission to access various dynamic performance views. This permission is used to obtain basic database information.

DBA permission needs to be granted.

Schema Objects

Permission to check schema objects to be evaluated. At least one object needs to be evaluated.

-

DBA

DBA permission required for subsequent operations.

DBA permission needs to be granted.