Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • find_idle_cpu.sql Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Histogram information Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • Convert multiple rows to single column Oracle
  • Index Range Scan Oracle
  • findobj.sql Oracle
  • S3 Basic info AWS
  • find_pdbs.sql Uncategorized
  • How to check current redo log progress redo_progress.sql Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • How to find who is using which Rollback segment and how many rows or blocks in that rollback segments, Oracle
  • Processes parameter and its dependencies on OS kernel parameters Linux/Unix
  • Rman Notes -1 Oracle

Creating never expiring DB user accounts in Oracle

Posted on 14-Sep-202314-Sep-2023 By Admin No Comments on Creating never expiring DB user accounts in Oracle

DB Users are required to reset the password periodically for better security. For some service accounts,  we need to make sure the password does not expire and does not impact the application.

For this purpose, we need to update that user’s Profile. Each Profile has multiple security settings that controls Password_life_time, password_reuse_time, password_reuse_max  settings. These are settings that control the behavior of Password.

    • PASSWORD_REUSE_TIME

The number of days passed before reusing the old password.

    • PASSWORD_REUSE_MAX

The number of password changes before reusing the old password.

To make DB User password never expire:

alter profile default 
limit 
password_reuse_time unlimited 
password_reuse_max unlimited 
PASSWORD_LIFE_TIME UNLIMITED;
Oracle, SQL scripts

Post navigation

Previous Post: Convert multiple rows to single column
Next Post: Read CSV File using Python

Related Posts

  • fkwoindex.sql /* Find FK without Index */ Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • get_vmstat.ksh for Solaris Oracle
  • CPU Core related projections AWS
  • Good notes on Oracle Events Oracle
  • Clean up Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • reset Sequence Oracle
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • Small sample shell program Linux/Unix
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • cif crons Linux/Unix
  • Oracle Release Explaination Oracle
  • Handling LOB data in Oracle Oracle
  • standard Monitoring – 1 Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme