Technology Blogs by SAP
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.
cancel
Showing results for 
Search instead for 
Did you mean: 
premsukh_bishnoi
Employee
Employee

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'