Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Connect to Oracle as dba

 
Vesko Jel
Ranch Hand
Posts: 30
  • 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
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • 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
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic