Skip to Content
Author's profile photo Prem Sukh Bishnoi

How to delete sap* from database level

  • Logon to database server and switch to ora<SID> user (e.g. oraalr) under UNIX (<sidadm> under Windows).
    Under Windows check correct settings of environment (ORASID, …).
    Start the database server manager with the command:
    sqlplus “/as sysdba”
    Now you’re able to execute SQL statements:
  • to view the entries of the “sap*” user type in following command:
    select * from <db_schema>.usr02 where mandt = ‘000’ and bname = ‘SAP*’; (maybe you have to change “mandt” to your client)
  • to delete the “sap*” user type in the following commands:
    delete from <db_schema>.usr02 where mandt = ‘000’ and bname = ‘SAP*’; (maybe you have to change “mandt” to your client)
    commit;
  • exit à exit the server manager

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo BASIS BASIS
      BASIS BASIS

      Thank you for your time on this post !

      This helped me 🙂