Comments
3 comments
-
Official comment
Hi Magnus,
As Jane L. Lovett kindly mentioned, this is likely a permissions issue in your environment. You can find a full list of the required permissions for SQL Prompt on the following webpage:
https://documentation.red-gate.com/sp/getting-started/requirements/sql-server-permissions
However the key permissions are:
User granted SELECT & VIEW DEFINITION on a database
User granted VIEW ANY DEFINITION
User is a member of the
sysadmin
roleUser is granted VIEW SERVER STATE
Can you confirm you have the above permissions set and let us know if the behavior changes?
-
The issue you are having is related to permissions in SQL Server. I think you should consider granting additional "VIEW DEFINITION" permissions on Unblocked Games Premium, this will allow SQL Prompt to access the metadata needed to display correct Intellisense information.
-
Try granting
VIEW DEFINITION
on the database — SQL Prompt needs it to access metadata for IntelliSense. Also, refresh suggestions withCtrl+Shift+D
.
Add comment
Please sign in to leave a comment.
Hi,
I'm using SQL Prompt 10.16.12 as normal SQL-user on SQL Server 2019. The user has only rights public, data_reader and data_writer on the current database.
Not any special permission on the server, and could only see his database, master and tempdb. BUT can select information_schema.*, sys.tables, sys.columns and so on, on current database.
Intellisense does not show any field of the current database. What right is missing?
Thanks a lot,
Magnus