1.创建用户
-------------------------------
SQL> create user wang
2 identified by wang123;
用户被创建
-----------------------------------
2.授权
-----------------------------------------
SQL> grant connect ,resource,dba to wang;
授权成功
SQL> commit;
提交完成
解锁用户:ALTER USER username ACCOUNT UNLOCK;