Home » Developer & Programmer » Forms » Employee Login Form (Oracle Forms 10g)
Employee Login Form [message #329817] Thu, 26 June 2008 11:31 Go to next message
alquarles
Messages: 2
Registered: May 2008
Location: New York
Junior Member
I created a code for Login Form:

declare
v_username VARCHAR2(25);
v_passwrd VARCHAR2(25);
a NUMBER;

begin
select username, passwrd
into v_username, v_passwrd
from login
where username = v_username
and passwrd = v_passwrd;

if v_username = :login.username
and v_passwrd = :login.passwrd then
call_form('MENU');
else
a := show_alert('ALERT_INVALID');
end if;

exception
when others then
a := show_alert('ALERT_LOGIN_ERROR');
end;


I want to change it so that only manager's usernames can be valid, everyone else shows a message "Only managers are allowed to login."
Re: Employee Login Form [message #329876 is a reply to message #329817] Thu, 26 June 2008 21:15 Go to previous messageGo to next message
cjack
Messages: 22
Registered: June 2008
Junior Member
Hi,

Do you have a column with user role?

If yes, you can select this column, then see whether equal manager....
Re: Employee Login Form [message #329883 is a reply to message #329817] Thu, 26 June 2008 22:23 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

How the oracle know the manager is login?

First think yourself for the above question and Make the remedy then u will find the soultion that how to avoid other than manager.

kanish
Previous Topic: LOV
Next Topic: Making a display item editable at time of insert and uneditable after an insert.
Goto Forum:
  


Current Time: Sat Dec 03 14:16:33 CST 2016

Total time taken to generate the page: 0.04060 seconds