cancel
Showing results for 
Search instead for 
Did you mean: 

How to delete SAP* account in Oracle

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Found it never mind.

Former Member
0 Kudos

What is the command I forgot the command.

Thank you in advance.

Former Member
0 Kudos

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;