Microsoft SQL Server as the Source Database Type
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
- Oracle as the Source Database Type
- MySQL as the Source Database Type
- GoldenDB as the Source Database Type
- Microsoft SQL Server as the Source Database Type
- PostgreSQL as the Source Database Type
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore