It's not a secret anymore!
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

Permission for root to access oracle

Minal Silimkar-Urankar
Ranch Hand

Joined: Nov 25, 2007
Posts: 136
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: 17168

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.

An IDE is no substitute for an Intelligent Developer.
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 15002

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 8 API documentation
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 17168

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:
subject: Permission for root to access oracle
jQuery in Action, 3rd edition