Home » Developer & Programmer » Forms » Urgent
Urgent [message #81614] Thu, 06 March 2003 00:25 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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;
Previous Topic: Re: Very Very Urgent --Report Printing
Next Topic: Firing Order Of Triggers
Goto Forum:
  


Current Time: Fri Apr 19 11:50:17 CDT 2024