• 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
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