View and change passwords for sys, system, sapr3

[Former Member]

Dear All

1.I need to view the password the for account :

sys, system, sapr3

2. I need to know for how long passwords have not been changed?

. and how can i change these passwords?

Any sugestions??

Regards

Rajesh

Edited by: rajesh sharma on Oct 15, 2008 1:51 PM

[Former Member · Accepted solution]

hi

you can change the passwords from brtools (best practise) and please change it from brtools.

at the same time you can use commands:

SQL> select name, ptime from user$;

select username, account_status, expiry_date from dba_users;

i hope this will be helpful to you.

regards

[debasissahoo]

Hi Rajesh,

1.I need to view the password the for account :
sys, system, sapr3

Its not possible to view the password, password is always encrypted format stored, if the default has not been changed for SYS, SYSTEM then their password are CHANGE_ON_INSTALL and MANAGER respectively.

2. I need to know for how long passwords have not been changed?
. and how can i change these passwords?

For knowing what date they were changed last,

- connect /as sysdba;

- SQL> select name, ptime from user$;

ptime will give you the last password change date.

you can view at what date the password will be expired by

- select username, account_status, expiry_date from dba_users;

change the password by brtools menu options or directly by chpass.

http://help.sap.com/saphelp_nw70/helpdata/EN/4f/c3883989676778e10000000a11402f/frameset.htm

Note -

Always recommended to use brtools for changing password rather than using the sql commands.

Regards,

Debasis.

Edited by: Debasis Sahoo on Oct 16, 2008 1:09 AM

[Former Member]

Hello,

I just answered a similar question:

And as far as I know, there is no way to see when passwords have been changed last time.

And there is no way to view passwords.