aspose file tools*
The moose likes Linux / UNIX and the fly likes Permission for root to access oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » Linux / UNIX
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: 16058
    
  21

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
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14146
    
  18

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: 16058
    
  21

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