Oracle 11g r2 ( Amazon RDS instance ) [message #614246] |
Mon, 19 May 2014 20:18 |
kesavansundaram
Messages: 183 Registered: October 2007 Location: MUMBAI
|
Senior Member |
|
|
Hi Team,
I am working with Amazon RDS Oracle instance. version. 11.2.0.2.
we have DEFAULT profile with below default values. But since we handle both password life time and grace time using Python code, we don't want to configure these 2 values in this profile. What value I can configure ? I just want to disable these 2 parameters.
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7 thank you
|
|
|
|
Re: Oracle 11g r2 ( Amazon RDS instance ) [message #614248 is a reply to message #614247] |
Mon, 19 May 2014 21:11 |
kesavansundaram
Messages: 183 Registered: October 2007 Location: MUMBAI
|
Senior Member |
|
|
Hi,
Yes, we don't have access to thier linux server. We are provisioning the instances through their UI console. Yes, I am not sure exactly what version it is and i was hoping they would have kept the datbases in 6.x versions...
We need to use DEFAULT profile as per our company policies. In our physical environment, we maintain below values:
DEFAULT PASSWORD_LIFE_TIME PASSWORD 90
DEFAULT PASSWORD_GRACE_TIME PASSWORD 3 Through Phyton code, we are rotating user's password after 90 days and we notify alert message before 3 days of password expiry.
Hence, we just need to disable these 2 values.
Can i set PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME to UNLIMITED ?
or PASSWORD_LIFE_TIME = UNLIMITED; PASSWORD_GRACE_TIME = 0 ?
Please guide me.
Thank you
|
|
|
|
|