Correct. Normal household lighting, whether incandescent, fluorescent or LED, will emit very little light of the type required to sustain plant photosynthesis. You can purchase lighting specifically designed for internal plant growth, used in indoor hydroponics etc, or a cheap alternative would be fish tank (aquarium) lighting. If you purchase a complete second hand unit the tank itself may function as a terrarium. Usually, aquarium lighting is of the type required to sustain photosynthesis of aquatic plants and will work for terrestrial plants as well, although probably not as well as specially lighting.