Updated on 2024-06-11 GMT+08:00

Microsoft SQL Server as the Source Database Type

Table 1 Check items for source database Microsoft SQL Server

Check Item

Description

Suggestion

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 ;

Schema objects

Permission to check schema objects to be evaluated.

At least one schema object is selected, or the evaluation task cannot be created.

NOTE:

The number of objects in system schemas of SQL Server is not checked.

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> ;

How Does UGO Check Database Permissions? FAQs

more