Skip to Content
avatar image
Former Member

Delete old OPS$ user

Hi!

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

What is the appropeiate SQL commando?

Thank you!

regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Apr 30, 2009 at 12:07 PM

    For windows:

    adapt the brackets with proper values:

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

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2009 at 09:44 AM

    Hi,

    Go through SAP NOTE 400241.

    Regards

    Nick Loy

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2009 at 09:45 AM

    check sap notes 50088 and 400241

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 30, 2009 at 09:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded