I know if you had done it the opposite way, where you granted the user or role minimum rights like db_datareader and db_datawriter, then you had to do GRANT VIEW ANY DEFINITION in order to give them the ability to see the definitions, which i think includes the successful use of sp_helptext.
try DENY VIEW ANY DEFINITION and see if that takes away that right.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!