Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util059.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>PASSWORD_FIRST_USE_OCCURRED Function</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-04-14T17:32:16Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="PASSWORD_FIRST_USE_OCCURRED Function" /> <meta name="relnum" content="Release 3.2" /> <meta name="partnum" content="E12510-01" /> <link rel="copyright" href="../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="../dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="up" href="preface" title="Home" type="text/html" /> <link rel="up" href="apex_util.htm" title="APEX_UTIL" type="text/html" /> <link rel="up" href="apex_util059.htm" title="PASSWORD_FIRST" type="text/html" /> <link rel="prev" href="apex_util058.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util060.htm" title="Next" type="text/html" /> </head> <body> <p id="BREADCRUMBING"><a href="preface" title="Home">Home</a> > <a href="apex_util.htm" title="APEX_UTIL">APEX_UTIL</a> > PASSWORD_FIRST</p> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="apex_util058.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util060.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDGCDII" name="CHDGCDII"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI159" id="AEAPI159"></a>PASSWORD_FIRST_USE_OCCURRED <a id="sthref309" name="sthref309"></a>Function</h1> <p>Returns true if the account's password has changed since the account was created, an Oracle Application Express administrator performs a password reset operation that results in a new password being emailed to the account holder, or a user has initiated password reset operation. This function returns false if the account's password has not been changed since either of the events just described.</p> <p>This function may be run in a page request context by any authenticated user.</p> <a id="sthref310" name="sthref310"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.PASSWORD_FIRST_USE_OCCURRED ( p_user_name IN VARCHAR2) <code>RETURN BOOLEAN</code>; </pre> <a id="sthref311" name="sthref311"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDCFBIH">Table: PASSWORD_FIRST_USE_OCCURRED Parameters</a> describes the parameters available in the <code>PASSWORD_FIRST_USE_OCCURRED</code> procedure.</p> <div class="tblformal"><a id="sthref312" name="sthref312"></a><a id="CHDCFBIH" name="CHDCFBIH"></a> <p class="titleintable">PASSWORD_FIRST_USE_OCCURRED Parameters</p> <table class="Formal" title="PASSWORD_FIRST_USE_OCCURRED Parameters" summary="This table describes the parameters available in the PASSWORD_FIRST_USE_OCCURRED function." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="31%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t86">Parameter</th> <th align="left" valign="bottom" id="r1c2-t86">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t86" headers="r1c1-t86"> <p><code>p_user_name</code></p> </td> <td align="left" headers="r2c1-t86 r1c2-t86"> <p>The user name of the user account</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref313" name="sthref313"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>PASSWORD_FIRST_USE_OCCURRED</code> function. Use this function to check if the password for an Application Express user account (workspace administrator, developer, or end user) in the current workspace has been changed by the user the first time the user logged in after the password was initially set during account creation, or was changed by one of the password reset operations described above.This is meaningful only with accounts for which the <code>CHANGE_PASSWORD_ON_FIRST_USE</code> attribute is set to <span class="bold">Yes</span>.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN FOR c1 IN (SELECT user_name from wwv_flow_users) LOOP IF APEX_UTIL.PASSWORD_FIRST_USE_OCCURRED(p_user_name => c1.user_name) THEN htp.p('User:'||c1.user_name||' has logged in and updated the password.'); END IF; END LOOP; END; </pre> <div align="center"> <div class="inftblnotealso"><br /> <table class="NoteAlso oac_no_warn" summary="" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p class="notep1">See Also:</p> <a href="apex_util007.htm#CHDFJCDH">"CHANGE_PASSWORD_ON_FIRST_USE Function"</a></td> </tr> </tbody> </table> <br /></div> <!-- class="inftblnotealso" --></div> </div> <!-- class="refsect1" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2003, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="../dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="apex_util058.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util060.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de