A summary of the differences between SYS and system in Oracle _oracle

Source: Internet
Author: User
1.
The SYS user has DBA authority and has the SYS mode to log in to the database only through SYSDBA. is the highest-privileged account in the Oracle database
System has DBA authority. But no SYSDBA permissions. Usually use this account to manage the database on it.
2.
(1) SYS--SYSDBA
System--sysoper
(2) STARTUP/SHUTDOWN/DBA Management Two can do

(3) SYS owns the data dictionary (Dictionay), or Dictionay belongs to the SYS schema.

(4) Sysdba more than sysoper the right to create database
3.
SYSDBA
Perform STARTUP and SHUTDOWN operations
ALTER Database:open, Mount, back up, or change character set
CREATE DATABASE
CREATE SPFILE
Archivelog and RECOVERY
Includes the restricted session privilege
Effectively, this is System privilege allows a user to connect as user SYS.
Sysoper
Perform STARTUP and SHUTDOWN operations
CREATE SPFILE
ALTER DATABASE Open/mount/backup
Archivelog and RECOVERY
Includes the restricted session privilege
This is privilege allows a user to perform basic operational tasks, but without the ability to look at user data

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.