1.oracle账号创建
CREATE USER "userName123" IDENTIFIED BY "pwd123" ACCOUNT UNLOCK DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE "DEFAULT";
GRANT "CONNECT" TO "userName123";
GRANT "RESOURCE" TO "userName123";
ALTER USER "userName123" DEFAULT ROLE "CONNECT", "RESOURCE";
GRANT CREATE SESSION TO "userName123";
GRANT UNLIMITED TABLESPACE TO "userName123";
2.删除账号
SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='userName123';
ALTER SYSTEM KILL SESSION '1523,1159';
drop user userName123 cascade;