forget super user id and password.

[Former Member]

HI experts,
i have forget my super user id and password,  could it be possible to retrieve through query.

[Former Member]

Hi Ambesh,

If you have only 1 Super User than you need to raise ticket to SAP and if you have 2 Super User than you can reset using other Super user id.

Thanks,

Harshal

[former_member227598]

Hi Negi,

Basically you can get User Code ID & password from OUSR table , But password cannot retrieve , update or change. You have to take SAP Support to raise the ticket for SAP support.

Rgds,

Kamlesh Naware

[kothandaraman_nagarajan]

Hi,

It is possible to get super user ID and password through query. But it is not possible to change password by query. Also do not try to password via UPDATE command. Please check with SAP support.

Run this query to get list of super user ID,

SELECT T0.[USER_CODE], T0.[U_NAME], T0.password FROM OUSR T0 WHERE T0.Superuser = 'Y'

Thanks

[Johan_H]

Hi,

You cannot retrieve it yourself, but SAP Support can reset it for you.

Regards,

Johan