I need to grant permissions to a login, and the login only needs to view stored procedures (contents not just names of SP's). I don't not want to grant him db_owner nor ddladmin roles. I granted him execution privilege, but he can only sees names of SP's not scripts. Any input will be helpful. Thanks.