1.以sysdba进入sql命令环境：
sqlplus / as sysdba;
2.创建用户如lal
create user lal identified by 123456;
3.授权
GRANT CREATE SESSION TO lal;
GRANT "CONNECT","RESOURCE" TO lal;
4.登录测试
sqlplus / as sysdba;
create user lal identified by 123456;
GRANT CREATE SESSION TO lal;
GRANT "CONNECT","RESOURCE" TO lal;