restricting access to stored procedures

I'm looking at giving other developers access to a development database, but I want to impose
tight restrictions on who can do what.  One thing I want to investigate is the ability to let them
execute stored procedures but not view them.

Is this pretty standard stuff?
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples