Skip to Content
avatar image
Former Member

How to delete SAP* account in Oracle

I need to delete the SAP* user account to gain access to a client because someone locked out all of the accounts. I know this can be done through interactive SQL but cannot remember which tables you have to hit. If someone could let me know that would be appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 20, 2006 at 04:03 PM

    Found it never mind.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Log on to the database with userid ora<sid> and execute the following SQL.

      delete from sap<SID>.usr02 where bname='sap*' and mandt='XXX';

      commit;