• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database newbie question about logging in

 
Steli Niculescu
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a task for an internship interview : a small JDBC application that uses an Oracle database. I have to send it to the interviewer to review it.
My code connects to my local testing Oracle XE database using user/pass "system"/"system" (that's the password i defined).

If I export the application into a JAR and send it, it will surely not work on the reviewer's machine because he probably has a different password
for the "system" user, and he will have to modify the code.

Is there a universal user (or something like this) for the Oracle database, for which i'm not required a password defined by me?

 
Jan Cumps
Bartender
Posts: 2584
11
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a universal user (or something like this) for the Oracle database, for which i'm not required a password defined by me?
No - and I am quite happy about that. It would be a major security breach.
It is also not advisable to use the Oracle System user in your application.
SYSTEM is a privileged administration user



You have several options:

- Ask the interviewer what the name and password and connection details of his database will be
- Use a configuration file, and provide the interviewer with instructions on how to set the parameters
- Create a login form that requests for this info.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic