Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
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;
