700字范文,内容丰富有趣,生活中的好帮手!
700字范文 > oracle的sys与sysdba用户有什么区别 – 数据库 – 前端

oracle的sys与sysdba用户有什么区别 – 数据库 – 前端

时间:2019-01-31 01:18:45

相关推荐

oracle的sys与sysdba用户有什么区别 – 数据库 – 前端

sys 就和linux/unix 里面的root用户 拥有超级权限sysdba 不是个用户吧 可以是个有特殊权限的连接模式 至于区别嘛 看下面的例子[clark@rhel3 bbed]$ sqlplus system/oracleSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:01 Copyright (c) 1982, , Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateORA-01031: insufficient privilegesSQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options[clark@rhel3 bbed]$ SQLplus system/oracle as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Nov 28 16:20:19 Copyright (c) 1982, , Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL>

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。