This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Soft Skills: The software developer's life manual and have John Sonmez on-line!
See this thread for details.
Win a copy of Soft Skills: The software developer's life manual this week in the Jobs Discussion forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connect to Oracle as dba

 
Vesko Jel
Ranch Hand
Posts: 30
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it possible to connect to oracle 10g like dba using thin driver, and then create user identified by password?
[ August 18, 2008: Message edited by: Vesko Jl ]
 
Paul Clapham
Sheriff
Pie
Posts: 20160
23
MySQL Database
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"Vesko J1", please check your private messages regarding an important administrative matter.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Vesko Jl:
Is it possible to connect to oracle 10g like dba using thin driver, and then create user identified by password?

[ August 18, 2008: Message edited by: Vesko Jl ]


You don't need to connect as sysdba for this. You can just assign create user privilages to the user you connect as.

Basically you can do anything possible via SQL or PL/SQL via JDBC.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic