OraFAQ Forum: General » Force password change if NEW user ?!?

Home » Other » General » Force password change if NEW user ?!?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Force password change if NEW user ?!? [message #103799]

Thu, 18 March 2004 03:50

saustin
Messages: 43
Registered: June 2003

Member

- Hi,
��When users are first set up on the system they are given a random password. Is there ANY easy way to force that new user to change the password the FIRST time they log in to the system. Took a look at intpwdch.sql but did not see anything obvious. Thanks, Steve. -

Report message to a moderator

Re: Force password change if NEW user ?!? [message #103813 is a reply to message #103799]

Wed, 24 March 2004 10:43

andrew again
Messages: 2577
Registered: March 2000

Senior Member

try this:

create user  zz  
identified by zz
PASSWORD EXPIRE
default tablespace users
temporary tablespace temp;

Report message to a moderator

Previous Topic:	ADO : recordset vs cursor
Next Topic:	help for ORA-07445

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 01 03:20:57 CDT 2026