Solved

Why root Access?

Posted on 2001-06-15
4
216 Views
Last Modified: 2010-04-21
Can someone tell me in some kind of priority why specifically you need root Access to UNIX. I am not a UNIX Administrator, but I am familiar with NT, WIN2K administrator roles. So I'm not a total idiot, just a partial one when it comes to UNIX. We have a Compaq Alpha running tru64 UNIX and our hosts say they need exclusive root access, which means our people don't have root access, they also want to take away our Oracle DBA priveleges. I hear a number of reasons from various people that we can't do this but nothing concrete.
What are the differences between root, sys, and system?

If the question requires more points please let me know that as well.

Regards


0
Comment
Question by:gosportlad
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 6

Accepted Solution

by:
bira earned 100 total points
ID: 6196535
Hi

 root

Is the super user default of the UNIX systems.
This user has the power to administrate all
system resources and to grant other users


SYS
When any database ORACLE is created, the user SYS,
identified by the password CHANGE_ON_INSTALL
is automatically created and granted the DBA role.
All of the base tables and views for the database
data dictionary are stored in the
schema SYS. These base tables and views are
 critical for the operation of Oracle.
 To maintain the integrity of the data dictionary,
 tables in the SYS schema are
manipulated only by Oracle; they should never be
 modified by any user or database
administrator, and no one should create any tables
in the schema of the user SYS.
Most database users should never be able to connect
 using the SYS account.
Most database users should never be able to connect
 using the SYS account.
You can connect to the database using this account
but should do so only when
instructed by Oracle personnel or documentation.

SYSTEM
When a database ORACLE is created, the user SYSTEM,
identified by the password
MANAGER, is also automatically created and granted
all system privileges for the database.
The SYSTEM username creates additional tables
and views that display
administrative information, and internal
tables and views used by Oracle tools.
Never create in the SYSTEM schema tables of
 interest to individual users.

0
 
LVL 6

Expert Comment

by:bira
ID: 6196812

  The AIX manual references root user as follow:

  root user.
  ----------
  The person who has unrestricted ability to
  access and modify any part of the
  operating system, usually the user who
  manages the system.
0
 
LVL 3

Expert Comment

by:mrn060900
ID: 6200381
root = administrator in NT

root = god on a unix system, they can do, look at, change anything they want.

Mike
0
 

Author Comment

by:gosportlad
ID: 6202641
Thanks, great help. Everything you have said, my hosts say they can provide roles for in UNIX. Sounds as though it's a control issue. They also claim that they cannot fully support the box if we have root privelges, although their track record indicates they aren't that good when it comes to providing fast and responsive support around issues on other boxes we have there.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A metadevice consists of one or more devices (slices). It can be expanded by adding slices. Then, it can be grown to fill a larger space while the file system is in use. However, not all UNIX file systems (UFS) can be expanded this way. The conca…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question