Yes, you can

GRANT EXECUTE ON tf_GetAllTicketNo TO username

(If you have a script for production), else do it via enterprise manager and set an object level permission.