This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes JDBC and the fly likes Connect to Oracle as dba Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Connect to Oracle as dba" Watch "Connect to Oracle as dba" New topic
Author

Connect to Oracle as dba

Vesko Jel
Ranch Hand

Joined: Jun 06, 2008
Posts: 30
posted private message
0
Quote
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
Bartender

Joined: Oct 14, 2005
Posts: 16483
    
    2

I like...
MySQL Database
posted private message
0
Quote
"Vesko J1", please check your private messages regarding an important administrative matter.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I like...
Eclipse IDE Hibernate Java
posted private message
0
Quote
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.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: Connect to Oracle as dba
 
Similar Threads
Does JDBC Use Certs or CA's ?
Which IT certificate is most valuable?
how to prepare for oracle dba
when 400 mark will reach?
Oracle on Solaris( or linux) & webpshere on winnt Connectivity