Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile 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
Pie
Posts: 20750
30
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