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

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

The user may not have the permission to access the table. Run the following statement to grant the VIEW DEFINITION permission to the user:

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

Permission to view definition.

The user without the permission cannot query meta information. Grant the View Definition permission to the user.

Run the following statement:

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