Sponsored Links
What is the specialty of SYS and SYSTEM account in Oracle Db ?
I know we can execute some special commands .. can u explain what are those
A:
SYS
owns the data dictionary and is the most powerful user in the database.
Other than installation of oracle packages and patches there is almost
never a reason to log in as SYS.
SYSTEM
owns a few more standard objects is the more common user for admin
functions but here to is not really needed as it too is an
over-privileged account for most purposes.
SYS is the most powerful user.. it has got the role SYSDBA
SYS is the owner of oracle dictionary
sys password is not maintained within database
sys can connect to database even when database instance is down
SYS- automatically created when Oracle database is installed
- automatically granted the DBA role
- has a default password: CHANGE_ON_INSTALL (make sure you change it)
- owns the base tables and views for the database data dictionary
- the default schema when you connect as SYSDBA
Tables
in the SYS schema are manipulated only by the database. They should
never be modified by any user or database administrator, and no one
should create any tables in the schema of user SYS. Database users
should not connect to the Oracle database using the SYS account.
SYSTEM- automatically created when Oracle database is installed
- automatically granted the DBA role
- has a default password: MANAGER (make sure you change it)
- used to create additional tables and views that display administrative information
- used to create internal tables and views used by various Oracle database options and tools
Never use the SYSTEM schema to store tables of interest to non-administrative users.
Page 1
|
| 
