- 理员帐户:SYS SYSTEM
- 管理权限:SYSDBA SYSOPER
Note:
The SYSDBA and SYSOPER system privileges allow access to a database instance even when the database is not open. Control of these privileges is totally outside of the database itself.
#显示当前用户
show user
#sqlplus 命令以系统管理权限 sysdba 连接数据库
sqlplus /nolog
SQL>connect / as sysdba
#或
sqlplus / as sysdba
#sqlplus 命令以 system 用户,密码为 test 登陆本机上的 tester数据库
sqlplus system/test@127.0.0.1:1521/tester
#以 sys 用户(密码 test)sysdba 管理权限登录
SQL>conn sys/test as sysdba