here is the exact error that i get when i execute sp_helptext as a db_datareader with execute rights on sp_helptext
Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54
The object 'USP_IE_GET_INVOICES_BY_USER_ID' does not exist in database 'ASE_WWF' or is invalid for this operation.
The stored proc that i am looking for does exist. I, as an admin, can see it exists.
Obviously i could not access sp_helptext with this user, prior to being granted execute rights on it.
I think that Mohammed Uddin had it right with the 2005 security being locked down. However, with each lockdown, there should be a way to allow it. Its only locked down by default. I would imagine that they (MS) would have provided us a way to hang ourselves, if that was what was wanted. They allow us to enable xp_cmdshell... though that is disabled as default.
I just dont know what is needed to allow this security...