MS Access Does Not Propagate ORA-28002 Password Will Expire Error
Last updated on JULY 05, 2017
Applies to:Oracle ODBC Driver - Version: 188.8.131.52 to 184.108.40.206 - Release: 9.2 to 11.2
Microsoft Windows (32-bit)
Password expiration is enabled, but Microsoft Access users do not receive a warning that their password is its grace period.
The issue can be reproduced with the following profile:
CREATE PROFILE graceperiod LIMIT
create user fred identified by fred;
grant connect, resource to fred;
ALTER USER fred PROFILE graceperiod;
Proceeding to login via MS Access is successful, and no warning appear.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms