使用oracle建新用户abc密码123456

打开命令提示符

输入：sqlplus

请输入用户名:  sys/xxx@orcl as sysdba
CREATE USER abc IDENTIFIED BY 123456;
GRANT CONNECT, RESOURCE, DBA TO abc;