How do I turn off Oracle password expiration?

by

To alter the password expiry policy for a certain user profile in Oracle first check which profile the user is using:

select profile from DBA_USERS where username="<username>";

Then you can change the limit to never expire using:

alter profile <profile_name> limit password_life_time UNLIMITED;

If you want to previously check the limit you may use:

select resource_name,limit from dba_profiles where profile="<profile_name>";

More Related Contents:

  1. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  2. How to describe performance issue in relational database?
  3. How do I escape a reserved word in Oracle?
  4. How to put more than 1000 values into an Oracle IN clause [duplicate]
  5. ORA-30926: unable to get a stable set of rows in the source tables
  6. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  7. Fetch Oracle table type from stored procedure using JDBC
  8. “Safe” TO_NUMBER()
  9. When or Why to use a “SET DEFINE OFF” in Oracle Database
  10. error: ORA-65096: invalid common user or role name in oracle
  11. Oracle insert if not exists statement
  12. Error : ORA-01704: string literal too long
  13. Oracle client ORA-12541: TNS:no listener [closed]
  14. Create an Excel Spreadsheet from a Oracle Database
  15. Faster alternative in Oracle to SELECT COUNT(*) FROM sometable
  16. Oracle date difference to get number of years
  17. SQL Fiddle Output Error
  18. oracle PL/SQL how to calculate range ip for IPv6 cidr
  19. How to find out when an Oracle table was updated the last time
  20. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  21. Oracle: how to add minutes to a timestamp?
  22. How to drop multiple interval partitions based on date?
  23. How to list active / open connections in Oracle?
  24. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  25. merge update oracle unable to get a stable set of rows
  26. How to get the week day name from a date?
  27. DBMS_JOB vs DBMS_SCHEDULER
  28. How to change default nls_date_format for oracle jdbc client
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment