Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Locktree.sql Oracle
  • DBMS_PROFILER for tuning PLSQL programs. Oracle
  • Session_info.ksh Linux/Unix
  • exp syntax in oracle 10g Oracle
  • Good notes on Oracle Events Oracle
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • dbms_job.submit example Oracle
  • Directory wise folder wise space usage Linux/Unix
  • fuser to check who is using diretory Linux/Unix
  • good note for shared pool tunnig Oracle
  • to see when crontab is changed. Linux/Unix
  • Very clear article about oracle dataguard Oracle
  • scripts to take listener.log backup Linux/Unix
  • To see how much time or progress of long transaction Oracle
  • Temporary Tablespsace Temp tablespace behaviour 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

  • Roles and Stored Procs II Oracle
  • Renaming the column name Oracle
  • lck.sql Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • Oracle Standby Database Library Index from Metalink Oracle
  • How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven) Oracle

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025
  • MYSQL and Oracle Comparison for Oracle DBA24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • proc.sql Oracle
  • plan10g.sql good1 Oracle
  • get_aix_vmstat.ksh Oracle
  • kill all processes from specific user in solaris. Linux/Unix
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • SAN Linux/Unix
  • Add new columns in dataframe Python/PySpark

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme