This week's book giveaway is in the Agile and other Processes forum.
We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line!
See this thread for details.
The moose likes Linux / UNIX and the fly likes Permission for root to access oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Engineering » Linux / UNIX
Reply Bookmark "Permission for root to access oracle" Watch "Permission for root to access oracle" New topic
Author

Permission for root to access oracle

minal silimkar
Ranch Hand

Joined: Nov 25, 2007
Posts: 133
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?


Minal Silimkar
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 14480
    
    7

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
Jesper de Jong
Java Cowboy
Bartender

Joined: Aug 16, 2005
Posts: 12921
    
    3

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.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 14480
    
    7

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Permission for root to access oracle
 
Similar Threads
Executing sqlplus or sqlldr from java code
Running apps installed as ROOT
Host credentials
Remote Access
Where to install Oracle in Solaris. Under users home?