在oracle中用命令创建用户并授权

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.登录测试