Password Expiration Date
Hi,
I was wondering if it is possible to change the format of the password expiry date that is checked each time a user attempts to login to the database.
I am using an 11g database with database profile password settings.
Currently the database stores a user's password expiration date as a Date and Time.
I am looking to see if it possible to simply make this a Date minus the timestamp, without the need to create a custom password expiration check.
i.e. the database continues to internally check the expiration date as a date instead of a date/time.
I was wondering if it is possible to change the format of the password expiry date that is checked each time a user attempts to login to the database.
I am using an 11g database with database profile password settings.
Currently the database stores a user's password expiration date as a Date and Time.
I am looking to see if it possible to simply make this a Date minus the timestamp, without the need to create a custom password expiration check.
i.e. the database continues to internally check the expiration date as a date instead of a date/time.
0