Oracle建立用户

create user Test_NJ identified by Test_NJ;
grant connect to Test_NJ
grant resource to Test_NJ
--设置权限
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO Test_NJ