SQL Server Permissions
Published 07 September 2020
To use SQL Prompt the SQL Server user will require the following permissions.
| Permission | Use | Core Functionality | Support Article |
|---|---|---|---|
| None | Format and refactor SQL code. See code analysis suggestions. | Yes | - |
| User granted SELECT & VIEW DEFINITION on a database | See suggestions in SQL Prompt for a database | Yes | Suggestions are not shown in SQL Prompt |
| User granted VIEW ANY DEFINITION | See suggestions for all linked servers in SQL Prompt | No | SQL Prompt is not showing all linked servers |
User is a member of the sysadmin role | See encrypted objects as suggestions in SQL Prompt | No | Unable to cast object of type 'System.DBNull' to type 'System.String' |
| User is granted VIEW SERVER STATE | Access encryption keys to generate suggestions | No | Suggestions are not shown in SQL Prompt |
