How can we help you today? How can we help you today?

SQL Prompt not working, missing rights?

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

Magnus P
1

Comments

3 comments

Sort by
  • Christian Perez
    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 role

    User is granted VIEW SERVER STATE

     

    Can you confirm you have the above permissions set and let us know if the behavior changes?

     

    Christian Perez
  • Jane L. Lovett

    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.

    Jane L. Lovett
    0
  • williamsstephens

    Try granting VIEW DEFINITION on the database — SQL Prompt needs it to access metadata for IntelliSense. Also, refresh suggestions with Ctrl+Shift+D.

    williamsstephens
    0

Add comment

Please sign in to leave a comment.