How to delete sap* from database level in Maxdb/sapdb

This document tell you , how to delete the sap* user from Maxdb/sapdb database level.

• Logon to database server
  1. switch to sqd<SID> user (e.g. sqdyak) under UNIX
  or
  2. logon as <sidadm> under Unix/Windows

  Start the SQL mode with the command:
  dbmcli -d <SID> -u control,<password> -uSQL <db_schema>,<password>
  sql_execute <sql statement> alternate
  sqlcli -d <SID> -u <db_schema>,<password> –> (version >= 7.5)
  <sql statement>

  Now you’re able to execute <sql statement>:

• to view the entries of the “sap*” user type in following command:
  select * from 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 usr02 where mandt = ‘000’ and bname = ‘SAP*’ (maybe you have to change “mandt” to your client)
  commit;
• quit or q(sqlcli)

sql_execute select * from users

Now you can logon to the system as user “sap*” with standard SAP password ‘pass’