We have a login with a db_datareader only permissions. However, this login cannot see stored procedures in SSMS object explorer and cannot select from sys.procedures (only built-in diagram-related sp are listed there).
What extra permissions should we give to a login to be able to see all stored procedures (not to execute them) and still be as read-only?
Thanks
you need "view definition"
August 1, 2022 at 1:57 pm
GRANT view definition TO [uRole_ViewDefinition/useraccount];
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 1, 2022 at 2:28 pm
Thanks both Frederico and Johan. That works exactly as I wanted. Wanted to mark Johan's response as an answer too, but the site apparently does not allow it for two responses.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply