ITPub博客

首页 > 数据库 > Oracle > 11g与12c默认用户区别

11g与12c默认用户区别

原创 Oracle 作者:sjw1933 时间:2022-10-20 10:59:24 0 删除 编辑

11g

SQL> conn sysbackup as sysbackup

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

 

12c

 

SQL> conn sysbackup as sysdbakup

SP2-0306: Invalid option.

Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM}] [edition=value]]

where <logon> ::= <username>[/<password>][@<connect_identifier>]

      <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

 

还有个 sysrac ,这些用户都是不能被删除的

 

CONNECT / AS SYSDBA  CONNECT / AS SYSOPER  CONNECT / AS SYSBACWP  CONNECT / AS SYSDG  / AS SYSKM

 

 

11g 默认用户

MGMT_VIEW

SYS

SYSTEM

DBSNMP

SYSMAN

SCOTT

VERIDATA

WLBLAZERS

OUTLN

FLOWS_FILES

MDSYS

ORDSYS

EXFSYS

WMSYS

APPQOSSYS

APEX_030200

OWBSYS_AUDIT

ORDDATA

CTXSYS

ANONYMOUS

XDB

ORDPLUGINS

OWBSYS

SI_INFORMTN_SCHEMA

OLAPSYS

ORACLE_OCM

XS$NULL

MDDATA

DIP

APEX_PUBLIC_USER

SPATIAL_CSW_ADMIN_USR

SPATIAL_WFS_ADMIN_USR

 

12c 默认用户

ORACLE_OCM

OJVMSYS

SYSKM

XS$NULL

GSMCATUSER

MDDATA

SYSBACKUP

DIP

SYSDG

APEX_PUBLIC_USER

SPATIAL_CSW_ADMIN_USR

SPATIAL_WFS_ADMIN_USR

GSMUSER

AUDSYS

FLOWS_FILES

DVF

MDSYS

ORDSYS

DBSNMP

WMSYS

APEX_040200

APPQOSSYS

GSMADMIN_INTERNAL

ORDDATA

CTXSYS

ANONYMOUS

XDB

ORDPLUGINS

DVSYS

SI_INFORMTN_SCHEMA

OLAPSYS

LBACSYS

OUTLN

SYSTEM

SYS

 


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/23825935/viewspace-2919311/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: 19c refresh pdb
请登录后发表评论 登录
全部评论
11年数据库行业经验,Oracle ACE、PG ACE、OCM、IBM Certified DBA、MySQL OCP、PolarDB技术专家、KCP、PCTP、PCSD、达梦师资认证、PolarDB开源社区技术顾问、ITPUB认证专家、某高校外聘教师

注册时间:2019-05-05

  • 博文量
    295
  • 访问量
    300726