iam nt avaible access sap* and pwd?

[Former Member]

hi sap gurus,

iam able to login with default user name and pwd.

so please is there any chance to change the defult usrname and pwd?

if thr is chance pls tell step by step process....

Regrads

sudheer

[Former Member · Accepted solution]

If you are looking to login with SAP*/pass, try the following

- On database level delete SAP* user for required client from table USR02

- Set the profile parameter login/no_automatic_user_sapstar to 0

- Restart the system

- Login with SAP*/pass

Regards,

Srikishan

[Former Member · Accepted solution]

thnxs srikishan

so please send the command for change datatable USER02.......

[hemanth2 · Accepted solution]

Dear Sudheer,

Hope you are doing good.

Start the database server manager with the command: sqlplus "/as sysdba"

Now you're able to execute SQL statements. To view the entries of the "sap*" user type in following command:

select * from <db_schema>.usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)

to delete the "sap*" user type in the following commands:

delete from <db_schema>.usr02 where mandt = '000' and bname = 'SAP*'; (maybe you have to change "mandt" to your client)

commit;

exit the server manager

To find out existing schemas: select * from all_users;

Now you can logon to the system as user "sap*" with standard SAP password 'pass'.

NOTE: If you delete SAP* user from DB but still can not logon to system with PASS, you must logon to any client and execute in the transaction code field /$tab to synchronize the buffers.

Hope this helps..

Thank you and have a nice day :).

_____________

Kind Regards,

Hemanth

SAP AGS

[Former Member · Accepted solution]

Thanxs Hemanth

but i entered the command sqlplus "/as sysdba" in command prompt it is connected to DB and ask username and pwd

i entered scott and tiger it shows protocol adapter error....

if u know any solution pls tell...........

[Former Member · Accepted solution]

Hi,

Looks like the database listener is not active.

Try starting the same using $ORACLE_HOME/bin/dbstart

Regards,

Srikishan

[Former Member · Accepted solution]

Hi Sudheer,

1. Goto RZ10

2. Open the Default profile in extended change mode.

3. Add the parameter login/no_automatic_user_sapstar = 0.

4. Save and activate the default profile.

5. Restart your SAP instance.

6. Now try to login to any client with sap* user with password PASS.

7. After login with sap* you change the password of your own user

Cheers...

Sudip

[Former Member]

Hi,

If you looking to Change the password of SAP*. Follow the below steps.

1. Create the User SAP* in the desired client and change the password as you like. If you don't want any one to Use the SAP*, lock the User.

This would be easy for you.

Regards,

Baskar.N

[Former Member]

Hi Bhaskar,

If you don't know the concept or question then please don't make people confuse. The question is not sap* password is reset using su01. If you forgot all users password then how you will login to the system.

Regards,

Sudip

[markus_doehr2]

The question how to reset the password of SAP* has been answered a hundred times here in the forum and on the net, you just have to do a google search.

Markus

[former_member204746]

I am locking this,

this is the most frequently asked question with SAP Basis...

[hemanth2]

Dear Sudheer,

Hope you are doing good.

I am not sure what the issue is, but if you are a end user, try the Tcode /nSu3 to change your password.

For more details do brief a little on the issue at hand.

Thank you and have a nice day :).

_____________

Kind Regards,

Hemanth

SAP AGS

[markus_doehr2]

> iam able to login with default user name and pwd.

Default user?

Markus