BASIS–如何刪除開發使用者的開發Key

使用者的開發Key儲存在DEVACCESS表中，如果由於審計需要刪除一些使用者的開發Key，而系統有限制SM30, SE16 or SE16N 等事務碼的使用，你就可以通過一個小程式去刪除開發Key。

 

代碼如下：

REPORT  ZBCDEVACCESS.

* ===================================================================
*  TITLE: Delete Record from Table DEVACCESS
*  DESCRIPTION: This program deletes the SSCR Developer Keys from the
*  table DEVACCESS. There is no maintenance dialog available via SM30
*  and thus this program is necessary.
* ===================================================================

TABLES: DEVACCESS.

 

PARAMETERS: p_user LIKE DEVACCESS-UNAME.

 

DELETE FROM DEVACCESS WHERE UNAME EQ p_user.

IF SY-SUBRC EQ 0.
   WRITE: /’User and key for ‘, p_user, ‘deleted from table DEVACCESS.’
ELSE.
   WRITE: /’Error deleting user and key for ‘, p_user, ‘ return code ‘, SY-SUBRC.
ENDIF.