Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

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,
0
epifanio67
Asked:
epifanio67
  • 2
3 Solutions
 
choukssaCommented:



ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

--choukssa
0
 
choukssaCommented:
also ...


ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;


--choukssa
0
 
sdstuberCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now