4 Configuring Privilege and Role Authorization - Oracle Help Center Users with explicit object privileges or those who connect with administrative privileges (SYSDBA) can access objects in the SYS schema The following table lists roles that you can grant to users who need access to objects in the SYS schema
Oracle数据库赋予用户sysdba权限(ORA-01031: insufficient privileges) 最近用windows本地的oracle时,sqlplus as sysdba连接数据库老是报ora-01031的错误,在网上查阅了大量教程,提供的解决思路大致如下: 方案一:将administator用户加入到ora_dba组 采用此方案的博主一直认为ora-01031错误时由于administrator用户不在ora_dba组,并提供了检查