Oracle11gR2: how to ensure passwords don't expire for all users via CLI?

hello experts,

How do I configure the database so passwords don't expire for all users via CLI?

I am aware of the security issues...

thanks so much experts....

regards,
epifanio67Asked:
Who is Participating?
 
choukssaConnect With a Mentor Commented:



ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

--choukssa
0
 
choukssaConnect With a Mentor Commented:
also ...


ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;


--choukssa
0
 
sdstuberConnect With a Mentor Commented:
the above posts assume your user has the DEFAULT profile.

If not, you will want to change DEFAULT to whatever profile the users have.

If they do have the DEFAULT, you also might want to consider creating a new special profile that is non-expiring for your users that are allowed that privilege
0
 
epifanio67Author Commented:
thank you experts....

sorry for the delay... was out of the office...

thanks again...

regards,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.