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’

To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply