change db connection user

[Former Member]

hi all,

I want to change the user for sap abab stack connect to database which default using SAPSID. Can anybody tell me how to do it?

Plz help me.

Best Regards,

Terry

[sunny_pahuja2 · Accepted solution]

please go through below link:

http://help.sap.com/saphelp_nwmobile71/helpdata/en/df/455ec9747111d6b25100508b6b8a93/frameset.htm

thanks

sunny

[Former Member]

hi,

Somebody tell me that it is impossible to change the user just using <SAPSID>. I think it is right.

Thanks for your help!

Best Regards,

terry

[Former Member]

check note Note 400241 - Problems with ops$ or sapr3 connect to Oracle

If you want to use the standard password "sap" and do not need the OPS$ mechanism, reset the <sapowner> password to "sap":

ALTER USER <sapowner> IDENTIFIED BY sap;