How to reset Password using ORACLE

[Former Member]

Dear Expert,

1. how can we reset Password using oracle.

2. is it mandatory to execute /$tab to reset buffer after resetting password using ORACLE

[former_member182034 · Accepted solution]

hi imran,

you did not mention the any specific user, anyways,, if you want to change the password of sap* then your can following command.

1. how can we reset Password using oracle.

For SAP user:

SQL> delete sapsr3.USR02 where bname='<User Name>' and mandt='client_number';

SQL> COMMIT;

For Oracle User:

brconnect -u system/<password> -f chpass -o <UseNamer> -p <password>

or

brconnect -u / -f chpass -o <UserNamer> -p <password>

2. is it mandatory to execute /$tab to reset buffer after resetting password using ORACLE

no

Regards,

[Former Member · Accepted solution]

Hi,

1. I wanna change password for SAP ID- XYZ, it is not any standard user of SAP like DDIC,SAP*. What would be the command for thiis.

2. Why we use T-code /$tab (used for resetting buffer) after password resettinng.

3. What is the SQL query if i have to change password of DDIC using ORACLE

[volker_borowski2 · Accepted solution]

Hi,

since the table holding the passwords is SAP bufferd, you need to reset the buffers

if you change the table on DB level, otherwise the table will not be refreshed in the SAP buffer.

It is not possible to change the SAP password from Oracle.

...

Well being very precise it is possible to adjust the password hash to another one,

but in this case you have to create/change the password through SAP one time before

and store the hash (Otherwise, the user will have a dfiffrent hash, that you will likely not be able

to match to a password.

But since this is a very intrusive change, you will get in serious trouble if any of your auditors finds out ...

Volker

[Former Member · Accepted solution]

Dear Sir,

What is the SQL query for changing password for SAP* & DDIC Using ORACLE

Will this SQL query ask for a new Password

[former_member182034 · Accepted solution]

Dear,

answer of you queries...

What is the SQL query for changing password for SAP* & DDIC Using ORACLE

SQL> delete sapsr3.USR02 where bname='SAP*' and mandt='client_number';

SQL> COMMIT;

Will this SQL query ask for a new Password

No.

hopefuly now you have to close this thread because you got the answer of your queries.

Regards,

[Former Member · Accepted solution]

Dear,

Thanks a lot for useful answer. but, i still have one query;

I wanna change password for SAP ID- XYZ, it is not any standard user of SAP like DDIC,SAP*. What would be the command for thiis.

[former_member188883 · Accepted solution]

Hi Imaan,

Your command should be

SQL> alter user <SAPSID> identified by <password>;

SQL> commit;

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak,

thanks.....

SQL> alter user <SAPSID> identified by <password>;

I asked for SAP USER ID not for SAPSID

Suppose i have SAP user ID -XYZ, i want to reset password/change for XYZ

[former_member188883 · Accepted solution]

Hi Imaan,

For changing password of SAP user id, best approach would be to use Transaction code SU01.

In case you need to perform the same using SQL command, here it goes

SQL> update <SAPSID>.USER02 set bcode ='new password> where mandt='<client>' and bname='<userid>';

SQL> commit;

I have never tried this but hope it helps you.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Thanks....

OK, let's see what happens. I'll give you output soon

[Former Member · Accepted solution]

Hi Imaan,

Pls read Volker Borowski's reply once again.

Br,

Venky

[Former Member · Accepted solution]

Hi Imaan,
> 
> Pls read Volker Borowski's reply once again.
> 
> Br,
> Venky

Hi,

Could you please help me understand Volker's words

[volker_borowski2 · Accepted solution]

> Hi Imaan,
> > 
> > Pls read Volker Borowski's reply once again.
> > 
> > Br,
> > Venky

>

> Hi,

>

> Could you please help me understand Volker's words

Maybe I should try myself

The table USR02 does not hold a password. The password is hashed, so to say one way forward encrypted.

There is no algorithm to decode the password. For logon, the password given by the user is hashed as well

and the hash is verified for authentification. (This is quite common and used i.e. for unix as well.

If you want details on this you'll be able to google some pages with detailed explaination easily.)

So you can not update the hash because you will never be able to "guess" what password would match.

The only option is to choose a password, change it through SAP, and then peek into the table to see what hash

had been stored. You might then use this known value to update another hash value with a "Known" value.

Meanwhile several hash algorithms are in place, so there is a code-type as well in the password table.

So you need to match both, hash AND code.

And again: Some auditors do not even know that this is possible, so if they catch you doing so, ...

Volker

[former_member289242]

Hello Imaan,

Kindly reset the passowrd with the help of following note:-

Note 562863 will help you reset the password on the oracle side.

Hope the above information helps.

Best Regards,

Gunjan

[Former Member]

Hi,

I don't think that it is possible to reset a SAP user's password from DB or OS level.

Only exception is user SAP*.

Regards,

Venkata S Pagolu.