Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Permission for root to access oracle

 
Minal Silimkar-Urankar
Ranch Hand
Posts: 136
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I installed oracle10g on Redhat Enterprice Linux.

For that, I created Oracle user and installed oracle on oracle user.
root or any other users do not have permission to access oracle.
I want to set permission for the root as well as for other users to access oracle.

How will I do that?
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18163
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Oracle permissions are not the same as OS permissions. The Oracle database user permissions are managed by Oracle itself, so you need to consult the Oracle docs.

Because the Oracle server is an OS process, it's assigned to an OS user in order to keep the OS secure, but the database users talk to the server, not to the OS.
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15284
39
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I recently installed Oracle 10g Express Edition (the free version of Oracle) on an Ubuntu machine. To be able to start and stop the database and do other things, I had to make myself a member of the 'dba' group. Read the Oracle documentation.
 
Tim Holloway
Saloon Keeper
Pie
Posts: 18163
53
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's right. Since Oracle itself is an OS process, if you want to control the Oracle server, you need appropriate OS privileges. If you just want to work inside of Oracle, you need an Oracle user acount. You can have either one or both, depending on how you need to interact with Oracle.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic