You may have come across the audit requirement to delete developers (developer keys) from your Development, Quality Assurance or Production system. Developer keys are stored in table DEVACCESS. If this table is not enabled in your system for maintenance via SM30, SE16 or SE16N transaction, you can write a small program and map it to a custom transaction, most likely with some basis authorizations so that not everyone can run it.
Please add the program heading according to your the programming standards your company has issued:
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.
Add
Add
Comments