I am having problem creating a new account that when the user login first time it gives him the password expired. I want the user to be able to change the password at initial login.
This is what I did.
I created the account user1 originally as:
create user user1 identified by "lzs3!RSESY"
default tablespace users
temporary tablespace temp
account unlock
password expire;
grant connect to user1;
GRANT CREATE SESSION TO user1;
-- ROLE
GRANT READ_ROLE TO user1;
Then user1 gets this error "status: Failure -Test failed: ORA-28001: the password has expired" at login. I changed the password using this command
alter user user1 identified by " bahPxD6!Mq" account unlock;
It works but did not prompts him to change password. I tried again to
alter user user1 identified by " x!rLrXoc2Y" account unlock password expire;
It says password expired.
So I checked
SELECT EXPIRY_DATE from dba_users where username = upper('user1');
EXPIRY_DATE
-----------
17-OCT-18
SELECT RESOURCE_NAME,LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME IN ('FAILED_LOGIN_ATTEMPTS','PASSWORD_LOCK_TIME');
RESOURCE_NAME LIMIT
------------------------- ----------
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LOCK_TIME 1
Please help.
Thank you.
[Updated on: Wed, 17 October 2018 14:56]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
