I'm pretty new on DBA functions in SQL server. I have a user who got data read access to SQL DB instances, however, he need to access the stored procedures with modified
permission(to see the inside content of all stored procedures) on the same schema.
How do I achive this, what are the permission setting?
Thanks in Advance.