create_user.sql

来自「通过串口连接短信猫进行短信的群发、单发、接收；管理群发订单、用户账户等」· SQL 代码 · 共 23 行

DECLARE
  i number(1);
BEGIN
  SElECT COUNT(*) INTO i FROM ALL_USERS WHERE upper(username)='&1';

  if i>0
  then
    EXECUTE IMMEDIATE 'drop user &1 cascade';
	end if;
END;
/

COMMIT;


create user &1
identified by "&2";

grant connect,resource to &1;

COMMIT;