Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Want to set password policy for database related user.

Want to set password policy for database related user.

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
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: Want to set password policy for database related user.

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

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Victor Fridyev
Honored Contributor

Re: Want to set password policy for database related user.

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
Entities are not to be multiplied beyond necessity - RTFM

Re: Want to set password policy for database related user.

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