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

1 Comment

You must be Logged on to comment or reply to a post.

BASIS BASIS

January 9, 2018 at 12:40 pm

Thank you for your time on this post !

This helped me 🙂