User Name SAP * user account not in validity date

[Former Member]

In my Test client whenever user want to login, message from system shows :

user account not in validity date.

for SAP * and and basis login also shows the same.

How to correct the same in the same client.

Reagrds,

Santosh

[Former Member · Accepted solution]

Hi

Yes set the parameter in instance profile login/no_automatic_user_sapstar = 0 through RZ10 or from OS level,bounce the server once done for parameter to take effect

Regards

Uday

[Former Member · Accepted solution]

My problem solved.

thanx for Nitin , Uday, Pravin,

[Former Member]

Hello Santosh,

Logon to the SAP client,use SU01 and give the user as sap*

go in the change mode and increase the validity of user account sap*

Rohit

[Former Member]

thanx for reply Rohit / Nitin

My problem is not solved.

(1) Using Oracle following error occurs :

SQL> connect /as sysdba

Connected.

SQL> delete from sap.usr02 where bname='SAP*' and mnadt= '017';

delete from sap.usr02 where bname='SAP*' and mnadt= '017'

*

ERROR at line 1:

ORA-00942: table or view does not exist

(2) Dear Rohot ,

I am unable to login to clinet (017) ,

But able to login in (021) Client. How can we change validity from client 021 to 017.

Regards,

Santosh

[Former Member]

Hello Santosh,

1. use sapr3.usr02 instead of sap.usr02

2. why are you not able to login in client 017,login with any user and then use SU01 to change the user sap*

Rohit

[Former Member]

First find out the schema

Select * from all_users

This should give you the users either it will sapr3 or sapsr3 or .... depneds on how you installed

Then do the delete using that schema

Pravin

[Former Member]

>

> thanx for reply Rohit / Nitin

>

>> SQL> delete from sap.usr02 where bname='SAP*' and mnadt= '017';

> delete from sap.usr02 where bname='SAP*' and mnadt= '017'

what is your system SID.

instead of sap.usr02 use sap<SID>.usr02 and try

It will work

Regards,

Nitin Salunkhe

Edited by: Nitin Salunkhe on Apr 28, 2009 10:42 AM

[Former Member]

Now using the schema i.e sapsr3 , using following script.

> delete from sapsr3.usr02 where bname='SAP*' and mnadt= '017'

> commit;

> exit

I have deleted for 000 and 017 client user id SAP*

After restart the SAP server ,System shows that : Name or password is Incorrect.( repeat logon)

Reagrds,

Santosh

[Former Member]

Hi santosh

check for profile parameter login/no_automatic_user_sapstar add this in your default profile and keep value 0.

default it is 1. so sap* is not allowed.

Regards,

Nitin Salunkhe

[Former Member]

My test server was Installed Heterogenous Copy, so in the (rz10 ) No profile is defined.

Shall I create the profile for the same. ?

Regards,

Santosh

[Former Member]

Hi santosh,

It seems your users validity is over.

you can login to oracle and delete sap* user and restart the system

It will create sap* user with default password PASS. use this to login your system and change other users validity.

login to oracle as follows

plsql / nolog

connect / as sysdba

delete from SAP<SID>.usr02 where bname='sap*' and mandt='000'

(where mandt is your client number)

Regards,

Nitin Salunkhe