SQL Permissions Required for SQL Prompt

GarryBGarryB Posts: 29 Bronze 1
in SQL Prompt
I have granted user view definition on the database role they are in, but they still report they do not get column and schema items returned via sql prompt.  What exact permissions will allow this and will being on a read only node have an affect?
Tagged:
· Share on Twitter

Answers

  • RichardLRichardL Posts: 417 Gold 4
    Hi @GarryB

    Thanks for your post. 

    You might need View Server State permissions but if that doesn't help, are you receiving permission errors and if so what are they please? 

    Kind regards

    Richard Lynch. 
    Customer Support
    Redgate Software
    · Share on Twitter
  • GarryBGarryB Posts: 29 Bronze 1
    Thanks for the response.  But something in the users settings got out of wake.  He did a reset default settings and everything started working as he expected.
    · Share on Twitter
Sign In or Register to comment.