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?
Comments
2 comments
-
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. -
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.
Add comment
Please sign in to leave a comment.