sysdba sysope 数据库中的两个内建的角色 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
sqlnet.ora文件
SQLNET.AUTHENTICATION_SERVICES= (NONE)
===>>>
#SQLNET.AUTHENTICATION_SERVICES= (NONE)
Show Parameter ROMOTE_LOGIN_PASSWORDFILE
如果
ROMOTE_LOGIN_PASSWORDFILE = none
是操作系统认证方式
ROMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE 或者 SHARE 是密码验证方式
还是REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE是密码验证方式?
REMOTE_LOGIN_PASSWORDFILE = share 什么的都是密码验证方式
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
(因为除了 Administrator 之外,还有 Oracle 的一些设置)在 控制面板->管理工具->计算机管理->本地用户和组->用户
选定用户之后,按右键 "属性" ,选 隶属于 去掉一个 ORA_DBA 的权限试试.