Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util087.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>UNEXPIRE_END_USER_ACCOUNT Procedure</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="UNEXPIRE_END_USER_ACCOUNT Procedure" /> <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_util087.htm" title="UNEXPIRE_END_..." type="text/html" /> <link rel="prev" href="apex_util086.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util088.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> > UNEXPIRE_END_...</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_util086.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util088.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDEDBIF" name="CHDEDBIF"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI187" id="AEAPI187"></a>UNEXPIRE_END_USER_ACCOUNT <a id="sthref465" name="sthref465"></a>Procedure</h1> <p>Makes expired end users accounts and the associated passwords usable, enabling a end user to log in to developed applications.</p> <a id="sthref466" name="sthref466"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT ( p_user_name IN VARCHAR2); </pre> <a id="sthref467" name="sthref467"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDECEJD">Table: UNEXPIRE_END_USER_ACCOUNT Parameters</a> describes the parameters available in the <code>UNEXPIRE_END_USER_ACCOUNT</code> procedure.</p> <div class="tblformal"><a id="sthref468" name="sthref468"></a><a id="CHDECEJD" name="CHDECEJD"></a> <p class="titleintable">UNEXPIRE_END_USER_ACCOUNT Parameters</p> <table class="Formal" title="UNEXPIRE_END_USER_ACCOUNT Parameters" summary="This table describes the parameters available in the UNEXPIRE_END_USER_ACCOUNT procedure." 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-t136">Parameter</th> <th align="left" valign="bottom" id="r1c2-t136">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t136" headers="r1c1-t136"> <p><code>p_user_name</code></p> </td> <td align="left" headers="r2c1-t136 r1c2-t136"> <p>The user name of the user account</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref469" name="sthref469"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>UNEXPIRE_END_USER_ACCOUNT</code> procedure. Use this procedure to renew (unexpire) an Application Express end user account in the current workspace. This action specifically renews the account for use by end users to authenticate to developed applications and may also renew the account for use by developers or administrators to log in to a workspace.</p> <p>This procedure must be run by a user having administration privileges in the current workspace.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN FOR c1 IN (SELECT user_name from wwv_flow_users) LOOP APEX_UTIL.UNEXPIRE_END_USER_ACCOUNT(p_user_name => c1.user_name); htp.p('End User Account:'||c1.user_name||' is now valid.'); 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_util021.htm#CHDIEFCE">"EXPIRE_END_USER_ACCOUNT Parameters"</a> and <a href="apex_util020.htm#CHDGFAHB">"END_USER_ACCOUNT_DAYS_LEFT 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_util086.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util088.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