Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Changing password expiration date

Changing password expiration date

From: Jens Lundell <lundellj_at_saic.com>
Date: 29 Oct 2001 19:36:39 -0800
Message-ID: <c4fbc557.0110291936.cd3a8da@posting.google.com>


How do I change a user's password's expiration date? The information is somehow stored in the sys.user$ table and the sys.dba_users view pulls information from there to construct a EXPIRY_DATE column. However, the view is built using 5 levels of nested decodes which is difficult to understand and I'm afraid of messing something up when playing around with sys.user$.

Using Oracle8i Enterprise Edition 8.1.6.1.0

-Jens Received on Mon Oct 29 2001 - 21:36:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US