oracle账号相关操作

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;