Urgent [message #81614] |
Thu, 06 March 2003 00:25 |
rajesh
Messages: 173 Registered: November 1998
|
Senior Member |
|
|
hi I want to Know answers for these 2 things
1. I need to Launch a Screen developed using forms 4.5
in my application which is developed using forms 6i
means i shld not convert the 4.5 form into 6i but i shld launch like a remote host
is this possible . If so pls tell me
2. @ any point user can get his userid & pwd by coding in forms right!!
is there any way this can be Prevented...
|
|
|
Re: Urgent [message #81615 is a reply to message #81614] |
Thu, 06 March 2003 02:04 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
dont make your subject URGENT ever again!
1- no, since your formsruntime [[active window]]is 6i, the 4.5 fmb cannot run in the same runtime window as long its not converted to forms 6i.
2- no.developers should not use those codes/built-ins
that shows passwords! actually it makes no point
since user has(should be) to login wit name and passw.
|
|
|
Re: Urgent [message #81617 is a reply to message #81614] |
Thu, 06 March 2003 02:24 |
Raj
Messages: 411 Registered: November 1998
|
Senior Member |
|
|
thanks Magnetic..
Reg User id.. ya i do agree
Is there any way to prevent the end user (other than the Developer) to see the User id..
|
|
|
Re: Urgent [message #81657 is a reply to message #81614] |
Sun, 09 March 2003 03:26 |
magnetic
Messages: 324 Registered: January 2003
|
Senior Member |
|
|
1.you shouldnt ever call forms 4.5 in a 6i runtime
becouse there are codes in the fmx file that 6i
runtime cannot interprete.
a possible way could be that you run the forms 4.5 runtime from 6i and open a 4.5 fmx in the called form 4.5 runtime [[if this opens as a new application.., but could lose control of the forms 4.5, just try...]]
but always put the formspath of 6i and 4.5 in the register
2.you should work with roles then userid checks..
example
i have a role named useApp1 in the database.
this roles are granted to oracle users userA and userB.
put in your main[[security]]screen a check
declare
v_user varchar2(30);
begin
select user
into v_user
from all_users u
, dba_roles r
where u.user=user
and r.role=useApp1
and u.user=r.user
[[ i dont know if both tables has the same user columns, but you see my point i hope]]
if v_user=user then
start forms1.fmx;
end if;
exception
when no_data_found then
message('U are not allowed to use this application');
end;
|
|
|