Oracle as the Source

DBMS_METADATA

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

Statements:

GRANT SELECT_CATALOG_ROLE TO <user>;

GRANT SELECT ANY DICTIONARY TO <user>;

or

GRANT DBA TO <user>;

If the role has been granted but the pre-check fails, run the following statement to check whether the role is DEFAULT_ROLE of the user:

SELECT GRANTED_ROLE, DEFAULT_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE='<user>' AND GRANTED_ROLE IN ('SELECT_CATALOG_ROLE', 'DBA');

If the query result is NO, run the following statement to grant the role:

ALTER USER <user> DEFAULT ROLE SELECT_CATALOG_ROLE;

or

ALTER USER <user> DEFAULT ROLE DBA;

Dynamic View

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

DBA permission needs to be granted.

DDL Object Count Check

The system checks whether a user has the permission to access at least one schema where DDL statements need to be evaluated.

Ensure that at least one schema object where DDL statements need to be evaluated can be accessed, or the evaluation task cannot be created. Note: Schema objects in Oracle are not collected.

DBMS_METADATA SQL Formatting Parameters

Permission to check whether the check result of DBMS_METADATA SQL Formatting Parameters is Alarm. If so, the evaluation project can be created, but the collected SQL format may be incorrect. As a result, the evaluation and conversion fail.

Check whether the DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, \'CONSTRAINTS_AS_ALTER\', false) and DBMS_METADATA.SET_TRANSFORM_PARAM(dbms_metadata.SESSION_TRANSFORM, \'SQLTERMINATOR\', true) statements can be executed.