Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\images\doc\AEAPI\apex_util084.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>STRONG_PASSWORD_VALIDATION 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="STRONG_PASSWORD_VALIDATION 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_util084.htm" title="STRONG_PASSWORD" type="text/html" /> <link rel="prev" href="apex_util083.htm" title="Previous" type="text/html" /> <link rel="next" href="apex_util085.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> > STRONG_PASSWORD�</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_util083.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util085.htm"><img src="../dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CHDCIGBH" name="CHDCIGBH"></a></p> <hr /> <div class="refsect1"> <h1><a id="sthref450" name="sthref450"></a><a name="AEAPI184" id="AEAPI184"></a>STRONG_PASSWORD_VALIDATION Function</h1> <p>This function returns formatted HTML in a VARCHAR2 result based on whether or not a proposed password meets the password strength requirements as defined by the Oracle Application Express site administrator.</p> <a id="sthref451" name="sthref451"></a> <p class="subhead2">Syntax</p> <pre xml:space="preserve" class="oac_no_warn"> FUNCTION STRONG_PASSWORD_VALIDATION( p_username IN VARCHAR2, p_password IN VARCHAR2, P_OLD_PASSWORD IN VARCHAR2 DEFAULT NULL, P_WORKSPACE_NAME IN VARCHAR2) RETURN VARCHAR2; </pre> <a id="sthref452" name="sthref452"></a> <p class="subhead2">Parameters</p> <p><a href="#CHDJFAEE">Table: STRONG_PASSWORD_VALIDATION Parameters</a> describes the parameters available in the <code>STRONG_PASSWORD_VALIDATION</code> function.</p> <div class="tblformal"><a id="sthref453" name="sthref453"></a><a id="CHDJFAEE" name="CHDJFAEE"></a> <p class="titleintable">STRONG_PASSWORD_VALIDATION Parameters</p> <table class="Formal" title="STRONG_PASSWORD_VALIDATION Parameters" summary="This table describes the parameters available in the STRONG_PASSWORD_VALIDATION 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-t131">Parameter</th> <th align="left" valign="bottom" id="r1c2-t131">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t131" headers="r1c1-t131"> <p><code>p_username</code></p> </td> <td align="left" headers="r2c1-t131 r1c2-t131"> <p>Username that identifies the account in the current workspace</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t131" headers="r1c1-t131"> <p><code>p_password</code></p> </td> <td align="left" headers="r3c1-t131 r1c2-t131"> <p>Password to be checked against password strength rules</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t131" headers="r1c1-t131"> <p><code>p_old_password</code></p> </td> <td align="left" headers="r4c1-t131 r1c2-t131"> <p>Current password for the account. Used only to enforce "new password must differ from old" rule</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t131" headers="r1c1-t131"> <p><code>p_workspace_name</code></p> </td> <td align="left" headers="r5c1-t131 r1c2-t131"> <p>Current workspace name, used only to enforce "password must not contain workspace name" rule</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --> <a id="sthref454" name="sthref454"></a> <p class="subhead2">Example</p> <p>The following example shows how to use the <code>STRONG_PASSWORD_VALIDATION</code> procedure. It checks the new password '<code>foo</code>' for the user '<code>SOMEBODY</code>' meets all the password strength requirements defined by the Oracle Application Express site administrator. If any of the checks fail, then the example outputs formatted HTML showing details of where the new password fails to meet requirements.</p> <pre xml:space="preserve" class="oac_no_warn"> DECLARE l_username varchar2(30); l_password varchar2(30); l_old_password varchar2(30); l_workspace_name varchar2(30); BEGIN l_username := 'SOMEBODY'; l_password := 'foo'; l_old_password := 'foo'; l_workspace_name := 'XYX_WS'; HTP.P(APEX_UTIL.STRONG_PASSWORD_VALIDATION( p_username => l_username, p_password => l_password, p_old_password => l_old_password, p_workspace_name => l_workspace_name)); END; </pre></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_util083.htm"><img src="../dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="apex_util085.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