-
Password/Login for ONLY certain PL/SQL web pages
Hello,
Currently I have a login/password feature for my PL/SQL web based application. Under the Database Access Descriptor Setting I set the Authentication Mode to PerPackage. I have an authorization function that follows – it is part of a package.
---------------------------------------------------------------------------------------
FUNCTION AUTHORIZE RETURN BOOLEAN
IS
v_user VARCHAR2(100);
v_password VARCHAR2(100);
BEGIN
owa_sec.set_protection_realm('ITCOM''s Database of IT Consulting Companies');
v_user := UPPER(owa_sec.get_user_id);
v_password := UPPER(owa_sec.get_password);
IF v_user = 'DOUG' AND v_password = 'DOUG'
OR v_user = 'HALL' AND v_password = 'HALL'
THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END AUTHORIZE;
---------------------------------------------------------------------------------------
Currently when I go to any webpage of the application I am asked to input a username and password to gain access. Once I have input the username and password I can access any webpage of the application and use the various features of the application. If I close the browser and I want to use the application again I have to input the password and login again. What I would like to do is:
Allow the user to view certain parts of the application without needing to input a password and login. For instance to view and search for information in the database no password/login is required.
---------------------------------------------------------------------------------------
BUT for the procedures that add, update and delete. Only then would the application ask for the password and login.---------------------------------------------------------------------------------------
Any ideas
Thanks
Doug
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|