Is there some way to prevent standard users from running "show
procedure xxx;" or similar?

I don't want reveal any business logic...