aspose file tools*
The moose likes JDBC and the fly likes Connect to Oracle as dba Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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
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: 18986
    
    8

"Vesko J1", please check your private messages regarding an important administrative matter.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

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://aspose.com/file-tools
 
subject: Connect to Oracle as dba