[Oracle]How to Disable/Enable Oracle User Account

Disable Oracle User Account

  
  DECLARE
      P_USER_NAME      VARCHAR2(100) :='A0001'; --帳號
      P_FND_END_DATE DATE := TO_DATE('2022/12/29','YYYY/MM/DD'); --帳號啟動時間
  BEGIN
    --關閉帳號
    FND_USER_PKG.UPDATEUSER(X_USER_NAME => P_USER_NAME,
                            X_OWNER     => NULL,
                            X_END_DATE  => P_FND_END_DATE);
  END;
 

Enable Oracle User Account
 
  DECLARE
      P_USER_NAME      VARCHAR2(100) :='A0001'; --帳號
      P_FND_START_DATE DATE := TO_DATE('20221229','YYYYMMDD'); --帳號啟動時間
  BEGIN
    --使用FND_USER_PKG.UPDATEUSER失效日期壓空值沒有作用，改用FND_USER_PKG.ENABLEUSER
    FND_USER_PKG.ENABLEUSER(USERNAME   => P_USER_NAME,
                            START_DATE => P_FND_START_DATE);
  END;