• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

Permission for root to access oracle

 
Ranch Hand
Posts: 136
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Saloon Keeper
Posts: 28764
211
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Posts: 28764
211
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
reply
    Bookmark Topic Watch Topic
  • New Topic