Solved

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

Posted on 2011-03-18
4
547 Views
Last Modified: 2013-11-11
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
Comment
Question by:epifanio67
  • 2
4 Comments
 
LVL 2

Accepted Solution

by:
choukssa earned 334 total points
ID: 35168974



ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

--choukssa
0
 
LVL 2

Assisted Solution

by:choukssa
choukssa earned 334 total points
ID: 35168979
also ...


ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED;


--choukssa
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 166 total points
ID: 35170310
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
 

Author Closing Comment

by:epifanio67
ID: 35184543
thank you experts....

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

thanks again...

regards,
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
passing parameters to sql script oracle 4 58
Oracle - Query link database loop 8 40
Read XML values 8 41
PL/SQl Expanding the WHERE statement in query 3 13
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question