sap* - different from the others

[Former Member]

Hi,

I have to connect to sap* through pass, automatic sap* parameter is enabled. However we do not know the password for sap*.

We tried connecting to the database, executed, delete from sap<sid>.usr02 where bname='sap*' and mandt='xxx';

After this we get an msg which says 'changes cannot be made on some tables or views'

Any suggestions Gurus.

Regards,

Sebastian.P

[Former Member]

Hi,

Why you are taking a critical approach. You can delete the SAP* account (ofcourse with management approval), which will create the SAP* outside the User Master Records, which will allow you to login with the default password. You can change back the password after successful login.

Hope this helps!!

Regards,

Raghu

[ashish_mishra2]

Sebastian,

It seems that you are using wrong schema for sapuser table.

1. Check you DB schema.

SQL> select username from dba_users;

USERNAME

-

---

SAPSR3

DBSNMP

...........

2. SQL> select bname,uflag,mandt from sapsr3.usr02 where bname like 'SAP*' and mandt=123;

BNAME UFLAG MANDT

-

---

-

---

-

---

SAP* 64 123

3. Rename sap* user

SQL> update sapsr3.usr02 set bname='SAP.OLD' where bname='SAP' and mandt=123;

1 row updated.

SQL> commit;

Commit complete.

4. Now login to your system with 'SAP* 'and 'pass' . You should be able to.

let us know in case you face any difficulty or error message in doing so.

Cheers !!!

Ashish Mishra

[Former Member]

Hi Sebastian,

Which ID did you use to connect to DB ? Does that ID have the relevant authorization present in ora<SID> ?

Regards,

Hari Kishan

[former_member227283]

Hi,

Where you are getting this message ?

'changes cannot be made on some tables or views'

Thanks

Anil

[Former Member]

Hi,

The default password for sap* user is the master password. This is the password for DDIC user.

Regards,

Sangeetha

[Former Member]

Hello

Please try to follow below

login with ora user ,go to sql promt

1. delete from <schema id >.usr02 where bname = 'SAP*' and mandt = '000';

if you get any previous error ,then let us know where you get that

2. if you have any other user by any chance try to do $sync in sap system which will clear memory buffer

but be careful while resetting any buffer

3. now try to log in with sap*/pass

4. if you are successful then change the parameter for SAP* login

Hope helps

Succes!!