创建oracle用户 荣

create user ivsmtest2 identified by ivsmtest2;
grant CONNECT to ivsmtest2;
grant DBA to ivsmtest2;
grant create any table to ivsmtest2;
grant insert any table to ivsmtest2;
grant delete any table to ivsmtest2;
grant select any table to ivsmtest2;
grant drop any table to ivsmtest2;
grant under any table to ivsmtest2;
grant alter any table to ivsmtest2;
grant update any table to ivsmtest2;
grant comment any table to ivsmtest2;
grant unlimited tablespace to ivsmtest2;
commit;
原文地址:https://www.cnblogs.com/admin11/p/1544875.html