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

原文地址:https://www.cnblogs.com/xiaoan-one/p/5368050.html