All you have to do is get into the database you want your users (dev team) can use the sp_helptext proc and select properties Option

You will see the permissions tab...