Oracle-L: RE: Initial User Login

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Tue, 04 Feb 2003 09:05:06 -0800
Message-ID: <F001.005435D0.20030204090506@fatcity.com>

Hi Rick,

You can use CREATE USER .. EXPIRE or ALTER USER EXPIRE.

For eg. create user xyz identified by abc password expire

This should make him change the password on the first logon.

Regards,
Charu
-----Original Message-----
JRicard982_at_aol.com
Sent: Tuesday, February 04, 2003 4:54 PM To: Multiple recipients of list ORACLE-L

Hello List,

We are trying to force a user to change their password when they login to the system for the first time after the user has been created. Is there a view or another way to make that determination? Any help would be greatly appreciated.

Thanks
Rick

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
  INET: JRicard982_at_aol.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

*********************************************************
Disclaimer

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Charu Joshi
  INET: joshic_at_mahindrabt.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Tue Feb 04 2003 - 11:05:06 CST