Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between a sys and system user and
what are the extra privileges available to the sys user?
- 1 Answers
- 5895 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sandip patil
SYS is the owner of the oracle dictionary.
THE DEFAULT superuser or like a 'root' in a oracle database.
Oracle strongly recomends NOT TO use SYS for any regular
adminstration tasks.
please have a look here
http://www.orafaq.com/usenet/comp.databases.oracle.server/20
03/08/06/0511.htm
system is just another account with administrative privs (
by default cannot start/shut databases)
quoting docs
"The Oracle user SYS owns all base tables and user-
accessible views of the data dictionary. Therefore, no
Oracle user should ever alter (update, delete, or insert)
any rows or schema objects contained in the SYS schema,
because such activity can compromise data integrity. The
security administrator should keep strict control of this
central account."
"When a database is created, the user SYSTEM is also
automatically created and granted the DBA role.
The SYSTEM username is used to create additional tables and
views that display administrative information, and internal
tables and views used by various Oracle options and tools.
Never create in the SYSTEM schema tables of interest to
individual users."
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to define an oracle cursor variable?
How many types of tables supported by oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
is there a tool to trace queries, like profiler for sql server?
How to count groups returned with the group by clause in oracle?
How to create an oracle database manually?
How to load data through external tables?
What is an oracle table?
Does oracle partitioning improve performance?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How to start a new transaction in oracle?
How do I limit the number of oracle database connections generated by weblogic server?
What is a lookup table in oracle?
What is the Tune Query
