Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util058.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>LOCK_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="LOCK_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_util058.htm" title="LOCK_ACCOUNT Procedure" type="text/html" /> <link rel="prev" href="apex_util057.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util059.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> > LOCK_ACCOUNT Procedure</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_util057.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util059.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDGCCHI" name="CHDGCCHI"></a></p> <hr /> <div class="refsect1"> <h1><a name="AEAPI158" id="AEAPI158"></a>LOCK_ACCOUNT <a id="sthref304" name="sthref304"></a>Procedure</h1> <p>Sets a user account status to locked. Must be run by an authenticated workspace administrator in the context of a page request.</p> <a id="sthref305" name="sthref305"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> APEX_UTIL.LOCK_ACCOUNT ( p_user_name IN VARCHAR2); </pre> <a id="sthref306" name="sthref306"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDIEHGF">Table: LOCK_ACCOUNT Parameters</a> describes the parameters available in the <code>LOCK_ACCOUNT</code> procedure.</p> <div class="tblformal"><a id="sthref307" name="sthref307"></a><a id="CHDIEHGF" name="CHDIEHGF"></a> <p class="titleintable">LOCK_ACCOUNT Parameters</p> <table class="Formal" title="LOCK_ACCOUNT Parameters" summary="This table describes the parameters available in the LOCK_ACCOUNTprocedure." 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-t84">Parameter</th> <th align="left" valign="bottom" id="r1c2-t84">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t84" headers="r1c1-t84"> <p><code>p_user_name</code></p> </td> <td align="left" headers="r2c1-t84 r1c2-t84"> <p>The user name of the user account</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref308" name="sthref308"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>LOCK_ACCOUNT</code> procedure. Use this procedure to lock an Application Express account (workspace administrator, developer, or end user) in the current workspace. This action locks the account for use by administrators, developers, and end users.</p> <pre xml:space="preserve" class="oac_no_warn"> BEGIN FOR c1 IN (SELECT user_name from wwv_flow_users) LOOP APEX_UTIL.LOCK_ACCOUNT(p_user_name => c1.user_name); htp.p('End User Account:'||c1.user_name||' is now locked.'); 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_util089.htm#CHDBFABJ">"UNLOCK_ACCOUNT Procedure"</a> and <a href="apex_util030.htm#CHDIFICC">"GET_ACCOUNT_LOCKED_STATUS 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_util057.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util059.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