Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 8th, 2004, 08:16 AM
Registered User
 
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Three attempts for password


Hello,

could somebody help me with password code!

i have the code as follows but i don't know how to do "loop" to give the user three attempts before systme close the form!

PROCEDURE PWD_VALIDATION IS
    alert_choice number;
BEGIN
    if:PWD.password = 'oracle'then
      go_block('WELCOME');
  else
      if:PWD.password <> 'oracle'then
          alert_choice := show_alert ('ALERT');
                if alert_choice = alert_button1 then
                      exit_form;
                end if;
      end if;
  end if;

END;


waiting for your replies ..


thanks in advance



 
Old January 8th, 2004, 06:51 PM
Registered User
 
Join Date: Sep 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think may be this will help you

PROCEDURE PWD_VALIDATION IS
    alert_choice number;
BEGIN
For i in 1..3 loop
 if:PWD.password = 'oracle'then
      go_block('WELCOME');
  else
      if i = 3 then
        exit_form
      end if;
      if:PWD.password <> 'oracle'then
          alert_choice := show_alert ('ALERT');
                if alert_choice = alert_button1 then
                      exit_form;
                end if;
      end if;
  end if;
 end loop
END;



Waheed rashwan
 
Old March 11th, 2004, 03:02 PM
aas aas is offline
Authorized User
 
Join Date: Mar 2004
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to aas
Default

What for to devise a bicycle? It is enough to customize profile and to assign this profile to the user. Oracle itself will interrupt attempts of the user to join a DB more than is indicated of count.






Similar Threads
Thread Thread Starter Forum Replies Last Post
password encryption angshujit ASP.NET 2.0 Basics 1 January 4th, 2007 03:34 PM
username and password abhi_loveu2002 ASP.NET 2.0 Basics 1 December 14th, 2006 05:25 AM
Need help password encrypt flyfish SQL Server 2000 9 July 12th, 2005 01:23 PM
Password rajuru PHP Databases 1 February 10th, 2005 12:05 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.