Sqlplus "/as
sysdba"
delete from sapr3.usr02 where bname='SAP*' and mandt='<Client number>';
commit;
Some SAP versions or more to say oracle version does not require commit and sap notes does not mention this as well, therefore no harm issuing the command.
symptoms are when you have deleted without using commit; and when you login client 000 with SAP* and password as PASS changes are the trace file will report "wrong login" but actually its not wrong login but more of commit is not performed.
Obviously make sure also profile parameter login_automatic_sapstart xx is set to 0 after deleting the users and bounce the sap before login...
wish you suceess and thats all.
commit;
Some SAP versions or more to say oracle version does not require commit and sap notes does not mention this as well, therefore no harm issuing the command.
symptoms are when you have deleted without using commit; and when you login client 000 with SAP* and password as PASS changes are the trace file will report "wrong login" but actually its not wrong login but more of commit is not performed.
Obviously make sure also profile parameter login_automatic_sapstart xx is set to 0 after deleting the users and bounce the sap before login...
wish you suceess and thats all.
No comments:
Post a Comment