SAP* no authorization in client 000

[Former Member]

Hello SAP Gurus,

I'm having a problem after a restore activity.

My next step is to config STMS, but I encounter license issue.

I logged in as SAP* since this is the only user allowed.

But as we logged in, there is no available authorization for SAP*.

I tried all the tcodes but still lacking of authorization.

I added the SAP* in database table UST04 with SAP_ALL and SAP_NEW profile.

I restarted SAP and DB, and when I try to access SLICENSE, the SAP* user still can not access any transactions.

Kindly assist, if I missed to add the user SAP* to other tables in database.

Thanks in advance for your help.

kharlos

[Former Member]

I added the SAP* in database table UST04 with SAP_ALL and SAP_NEW profile.

I would not touch SAP tables at database level to avoid consistency issues. Please use SU01. For lincense issues you may want to apply for temp license at service market place.

[Former Member]

Hi,

Please check if you can delete from SU01 as Manoj suggested.

Personally, I never happen to face database to be inconsistent while just deleting the user at database level, while following the correct process. But as Manoj suggested working from SAP level is always good.

Also, if still doesn't work, set the profile parameter "login/no_automatic_user_sapstar=0" in your instance profile and restart the SAP instance. (See OSS note 806819).

Regards,

Sujit.

[Former Member]

Hello All, thanks for the post your suggestion is very helpful.

kharlos

[Former Member]

To reset password of user SAP in ABAP stack on client 000, use this strategy:

For MS-SQL, you will use the SQL Management Studio and run a Query.

Use the following SQL:

delete from <sapsid>.USR02 where BNAME='SAP*' and MANDT='clientnumber'

You then need to change the instance parameter:

'login/no_automatic_user_sapstar = 0' (Zero) and restart the system. You can then logon to client '000' with User SAP* and password 'PASS'.

You then create your user ID in client '000' and recreate SAP* then change the instance parameter 'login/no_automatic_user_sapstar = 1' and restart the system.

[Former Member]

I would suggest to delete user sap* from the database and check if it is being created in the correct way with profile SAP_ALL.

Kind regards,

Mark

[Former Member]

thanks Mark, Are you suggesting that we should recreate the SAP* in the db table UST04 after deleting it?

kharlos

[Former Member]

Hi,

Please delete the SAP* user from database level (table USR02) and restart the SAP and try. It should work.

After you login please apply the valid license.

Also you can try with DDIC in 000 client. Anyway you should apply the license.

Let us know if you are facing any more difficulty.

Regards,

Sujit.

[Former Member]

No, SAP* is an internal user.. So if you delete it from table USR02, it will automatically be created again. Including the correct authorizations. After you have deleted it, you can logon with password pass.

Kind regards,

Mark

[Former Member]

Thanks Sujit, what will be the password of the SAP* after SAP restart since we are running ECC 6.0?

kharlos

[Former Member]

It's pass, like mentioned in my last post.

Kind regards,

Mark

[Former Member]

its pass.

IS your issue fixed?

Regards,

Sujit.

[sivakumar_kilari3]

This message was moderated.

[Former Member]

Thanks Kumar, the problem is that SAP* is the only account allowed in our SAP system, when we use DDIC in 000, it will prompt us to install saplicense.

kharlos

[sivakumar_kilari3]

This message was moderated.