create user cb identified by root; grant resource,connect to cb ; grant select any dictionary to cb ; grant select any sequence to cb ; grant select any table to cb ; grant create any table,alter any table,drop any table,create any view to cb ; grant select any table,update any table to cb ; grant insert any table,delete any table to cb ; grant create any table,alter any table,drop any table to cb ; grant create any trigger,alter any trigger,drop any trigger to cb ; grant create any procedure,alter any procedure,drop any procedure to cb ; grant create any sequence,alter any sequence,drop any sequence to cb ; grant create any synonym,drop any synonym to cb ;
windows服务器：打开cmd运行命令
输入 sqlplus /nolog ----- 实现无用户名登录
conn /as sysdba ----- 连接到数据本地数据
alter user system identified by password; ----- 修改system 密码 为password(你自定义的密码)
grant dba to scott; --授权scott用户为超级用户
