Want to set password policy for database related user.

[Gouranga Maiti]

Hi,
I want to set password policy (like password expiration time 60 days) to the users oradaq, davadm, daqadm. That user entry in /etc/passwd and what process the users are holding are given below. Now my question is is there any impact in application(or in database start/stop) after password expiration? Or simply user will provide new password when system prompt for new password and then can work without any problem.

/etc/password entry is :----
oradaq:svafgsu:3223:204:SAP Database Administration User:/oracle/DAQ:/usr/bin/ksh

davadm:asd.fgta.jYT:3207:209:SAP System Administrator:/home/davadm:/usr/bin/ksh

daqadm:BGZ9pRH,C.oT:3301:209:SAP System Administrator:/home/daqadm:/usr/bin/ksh

ps -eaf output is :------

oradaq 4897 1 0 Jul 29 ? 0:12 oracleDAQ (DESCRIPTION=(LOCAL=NO)(SDU=32768))

davadm 16068 2633 0 20:01:11 ? 1:04 dw.sapDAV_DVEBMGS01 pf=/usr/sap/DAV/SYS/profile/DAV_DVEBMGS01_d

daqadm 6904 4780 0 00:11:48 ? 3:40 dw.sapDAQ_DVEBMGS00 pf=/usr/sap/DAQ/SYS/profile/DAQ_DVEBMGS00_d


Thank you all in advance

With regards
Gouranga

[Yogeeraj_1]

hi Gouranga,

Your Oracle and Unix passwords are not related in any way. So when your Unix password has expired you will be prompted for a change. This will not affect the Oracle User password. The Oracle user may both be "identified externally" or by a "password". They will in no case be affected when the unix password expires.

hope this helps!

kind regards
yogeeraj

[Victor Fridyev]

Hi,

Oracle users passwords are not connected to UNIX ones, if in Oracle the users are not defined as "identifying externally", but in this case these users work as
#> sqlplus /
and don't input their oracle (or UNIX) passwords at all.

HTH

[Gouranga Maiti]

Thank you both.. Password policy has been set to above mentioned users.