create_user.sql

来自「使用短信猫可以实现短信的群发」· SQL 代码 · 共 14 行

declare 
	i number(1);
begin
	select count(*) into i from ALL_USERS where upper(username)='CN0705';
	if i>0 then
		execute immediate 'drop user cn0705 cascade';
	end if; 
end;
/

create user cn0705 identified by cn0705;
grant dba to cn0705;
commit;