• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Database newbie question about logging in

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?

 
Bartender
Posts: 2662
19
Netbeans IDE C++ Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Anything worth doing well is worth doing poorly first. Just look at this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic