cd /u01/app/oracle/product/11.2.0/xe/bin
./sqlplus / as sysdba
修改dba的密码
alter user sys identified by newpassword;
alter user system identified by newpassword;
创建新用户:用户名为admin 密码password(根据自己的情况写) 用system用户创建
create user admin identified by password; 创建admin用户设置密码
grant create session toadmin; 赋予admin用户登录权限
赋予admin用户各种权限
grant create view toadmin;
grant select any teble toadmin;
grant select any dictionary toadmin;
grant create table toadmin;
grant drop any table toadmin;
grant insert any table toadmin;
grant update any table toadmin;