Skip to content
Tuesday, March 21, 2023
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • 2015
  • March
  • How to check Last Password Change Time for a user in Oracle

How to check Last Password Change Time for a user in Oracle

Oracle
20 August 202020 August 2020 Administrator

SELECT name,

ctime,

ptime

FROM sys.user$

WHERE name = ‘SCOTT’;

NAME

CTIME

PTIME

SCOTT

02-17-2006 07:49:06

02-17-2006 08:40:09

Share this post: on Twitter on Facebook on Google+

Post Views: 340

Post navigation

Flashback Database
How to lock/unlock statistics on a table
Administrator

http://www.databaselearners.com

Related Posts

My Oracle Support Help

20 March 201520 August 2020 Administrator

SYSDBA AND SYSOPER

19 August 202019 August 2020 Administrator

Oracle Mechanism To Store Password

18 August 202018 August 2020 Administrator

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 0
  • 51,098

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.