1: Can another user access my Oracle tables on prophet?

Yes. Every user connects to the same database, "course". Each user has his/her own schema. If the user's schema is "UCID", if that user does a : "grant select on MyTable to public;", another user can then run "select * from UCID.MyTable;".

2: Can I access Oracle and Tomcat, and the university computers from off campus?

Yes. You must use a Virtual Private Network (VPN)

Note: You can also install an AFS client on your desktop, which greatly enhances your ability to use the University systems. In order to do so, follow these instructions.

~ ~