Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm attempting to create a role in Azure SQL such that the user can perform Select operations, view all schema (but not modify schema) but not perform any writes or execute stored procs. Granting a user Select permission gets me close. However, the user cannot see any stored procs or scalar functions.
So, I want to allow the user to see all schema definitions, not modify any schema objects and perform Selects. Is this possible?
Assign the VIEW ANY DEFINITION securable to the user.
That will allow them to see SP and view definitions but not allow them to change it.
https://technet.microsoft.com/en-us/library/ms175808(v=sql.105).aspx
VIEW ANY DEFINITIONsecurable will allow them to view the definitions of SPs and views.