sql server - T-SQL For GRANT View ONLY to Stored Procedures -

how write or grant permission user view stored procedures? don't want users dropping, editing or modifying procs.

ok have 2 things achieve looking for.

first have create execute role, grant user execute , see stored procedures on database.

create role db_executor grant execute db_executor exec sp_addrolemember 'db_executor', 'username' 

than have give user permission see them in way, described in article grant permissions view stored procedure text

grant view definition on yourstoredprocedurename [username]