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
Thank you for your time on this post !
This helped me 🙂