Password Expired [message #672550] |
Wed, 17 October 2018 14:55 |
wtolentino
Messages: 404 Registered: March 2005
|
Senior Member |
|
|
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
|
|
|
|
|
|
|
Re: Password Expired [message #672663 is a reply to message #672662] |
Mon, 22 October 2018 09:49 |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
Additionally, don't create a password with an "@" sign in. Oracle will interpret it as a connect string.
|
|
|