Oracle中sys和system的区别小结

前端之家收集整理的这篇文章主要介绍了Oracle中sys和system的区别小结前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

  1. SYS用户具有DBA权限,并且拥有SYS模式,只能通过SYSDBA登陆数据库。是Oracle数据库中权限最高的帐号
    SYSTEM具有DBA权限。但没有SYSDBA权限。平常一般用该帐号管理数据库就可以了。
    2.
    (1)sys -- sysdba
    system --sysoper
    (2)startup/shutdown/dba管理两个都能做 (3)sys拥有数据字典(dictionay),或者说dictionay属于sys schema (4)sysdba比sysoper多了一个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 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 privilege allows a user to perform basic operational tasks,but without the ability to look at user data

猜你在找的Oracle相关文章