How to create login form.(merged) [message #599236] |
Wed, 23 October 2013 02:55 |
|
jgjeetu
Messages: 373 Registered: July 2013 Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.
For exapmle i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.
My requirement is i want to create a basic login form which includes
Login i.e Text_item
Password i.e text_item
Login i.e push button
kindly tell what should be the queries behind these items.
and how to connect this form to database.
I am attaching file , just add working codes in that or you can write codes here also ,i will try to understand that if still i will have any problem then i will ask but for now i want codes only . Thanks
[Updated on: Wed, 23 October 2013 02:56] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: How to create login form. [message #599290 is a reply to message #599244] |
Wed, 23 October 2013 08:43 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
Ummm, create a table called login with a userid and a password and check against it. What do you not understand?
I would not use a column called NAME though. It is a reserved word.
I do not understand what you mean by connecting the form to a database.
[Updated on: Wed, 23 October 2013 08:44] Report message to a moderator
|
|
|
|
|
|
|
|
Re: How to create login form. [message #599348 is a reply to message #599335] |
Wed, 23 October 2013 15:30 |
|
jgjeetu
Messages: 373 Registered: July 2013 Location: www.Orafaq.com/Forum
|
Senior Member |
|
|
finally made few changes
create login table (id varchar(20) primary key,
pwd vrchar2(20))
insert into login values('ram','ram')
insert into login values('shyam','shyam')
select * from login
after that made changes according to that in login form(see above query)
>Now Tried to run that form again , this time no compliation error
but when entered username and password got error:- not connected to database. (i knew that this problem will arise thats y i asked how to connect this form to database)
(i have already created users ram and shyam and granted them create session )
now this final problem is remaining , hope someone could really help this time.
[Updated on: Wed, 23 October 2013 15:31] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
Re: How to create login form. [message #599462 is a reply to message #599457] |
Thu, 24 October 2013 12:22 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
@Littlefoot : I personally don't want to miss any opportunity to learn something new. May be mughal has something great which he has just emailed to OP or may be something which could be improvised. Also, a chance for a good technical discussion on this forum is lost. Of course, helping others is definitely good. Then why not help everybody by posting in the forum itself.
|
|
|
|
|
Re: How to create login form. [message #599494 is a reply to message #599466] |
Thu, 24 October 2013 15:23 |
|
mughals_king
Messages: 392 Registered: January 2012 Location: pakistan
|
Senior Member |
|
|
Dear @littlefoot yes you are right i posted in-complete inform. why i posted this link because he was saving user name and password same like ram/ram just i was trying to explain him what is password his information was like below yes you are right i am wrong i should explain him in detail i really like you on this forum because you have a great knowledge on this forum i use to learn from your logics which you alwayz posted to helps other peoples. Actually @jgjeetu is still in learning process that's why i was trying to teach him like this.
@jgjeetu
----------------------------------------------------
create login table (id varchar(20) primary key,
pwd vrchar2(20))
insert into login values('ram','ram')
insert into login values('shyam','shyam')
as far as concern what is custom login?
as per my knowledge which i learnt from like you peoples on this forum & taking help from internet of-course.
Custom login require exactly two form fields username & password oracle access manager supports authentication forms with two fields only.
Customwar and external context types, require logic within the custom login page to perform the following two tasks.
Send back the request "ID" the page received from the oracle access manager server.
I can explain more about custom login form even professionally i can send you how to create custom login form. I always trying to learn like you people who has a great knowledge on this forum.
Regard
Mughal
[Updated on: Thu, 24 October 2013 15:30] Report message to a moderator
|
|
|
|
|
|
|