Database can be accessed by all
When you say Oracle 10g Lite I assume you mean Express Edition.  I recommend you read through the documentation, particularly the section on Connecting to the Database.  If you have a more specific question after reading that, we would be glad to help.