on 02-25-2009 5:47 AM
Hi,
I am working on SAP solution Manager 7 with database 10g & OS win 2003 . When i check my oracle user account status using
select username,account_status from dba_users;
Than i get three user account status is expired .Can any body tell me now ,what action i have to take to resolved this issue.
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
OUTLN OPEN
OPS$TEGASOL\SOLADM OPEN
OPS$TEGASOL\SAPSERVICESOL OPEN
OPS$TEGASOL\SAPSERVICESR3 OPEN
SYS OPEN
SYSTEM OPEN
SAPSR3 OPEN
SAPSR3DB OPEN
TSMSYS EXPIRED
DIP EXPIRED
DBSNMP EXPIRED
11 rows selected.
Hi Rudra,
This means the users have been expired.....May be they are not used. If you want those users to be open then assign new passwords for those and can also set PASSWORD_LIFE_TIME to number of days he can use that password.
Regards,
Kalyan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The three database users thta you have mentioned doesnt plany any role in SAP environment
so if you are not facing any issues,you better dont touch them
You can refer to Note 562863 about these users
You can though increase the validity of user if you want
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.