Delete old OPS$ user

[Former Member]

Hi!

I would like to delete old OPS$ user from system copy.

What is the appropeiate SQL commando?

Thank you!

regards

[former_member204746 · Accepted solution]

For windows:

adapt the brackets with proper values:

DROP USER "OPS$[DOMAIN]\[OLDSID]ADM".SAPUSER" CASCADE;

DROP USER "OPS$[DOMAIN]\SAPSERVICE[OLDSID]".SAPUSER" CASCADE;

[Former Member]

Hi

Adding more you can also check this [Link|http://www.sap-img.com/basis/information-on-how-the-ops-users-work.htm]

Regards

Uday

[Former Member]

check sap notes 50088 and 400241

[Former Member]

Hi,

Go through SAP NOTE 400241.

Regards

Nick Loy