Microsoft SQL Server as the Source

DDL query

Permission to obtain database objects

Grant the permission to obtain database objects to the user.

Run the following statement:

GRANT SELECT ON OBJECT ;

DDL Object Count Check

Permission to access at least one schema object for which DDL statements need to be evaluated

If a user does not have the permission to access tables, run the following statement to grant the View Definition permission:

GRANT VIEW DEFINITION ON DATABASE :: <database> TO <user>;

In addition, you must have at least one schema object. Otherwise, the evaluation project cannot be created. The number of objects in schemas in a SQL Server database is not counted.

View Definition

Whether a user has the View Definition permission

A user without the View Definition permission cannot query metadata.

Run the following statement to grant the permission:

GRANT VIEW DEFINITION ON DATABASE :: <database> TO <user>;