In release previous to 12c, to get last login time details of the user, we have to enable “AUDIT SESSION” and then query the AUD$ table but in case of 12c we can get from table USER$ and in SPARE6 column.
USER$ table was in 11gR2 :
CTIME: Date & Time when user was created
PTIME: Date & Time when user password was last changed
LTIME: Date & Time when the user account was locked
LCOUNT: Number of failed login attempts
Below column added in 12c:
SPARE6: Last login time of the user.
USER$ table was in 11gR2 :
CTIME: Date & Time when user was created
PTIME: Date & Time when user password was last changed
LTIME: Date & Time when the user account was locked
LCOUNT: Number of failed login attempts
Below column added in 12c:
SPARE6: Last login time of the user.
No comments:
Post a Comment