Page 1 of 2
Multiple Instance of an Application.
Posted: Fri Jun 09, 2006 4:40 am
by Kashif
Asslam-o-Alaikum.
Is it Possible to Restrict a User to Open Multiple Instances of a Developer 6i Application?
User Can only RUN any Software ONCE.
Best Regards.
Muhammad Kashif
Posted: Fri Jun 09, 2006 7:07 am
by mirza_rehan
Assalam-o-Alaikum
write these code on Pre-Form trigger if you create different oracle user for every user.....
<b>Declare
v_count Number;
Begin
Select count(*) into v_Count
from v$session
where username = user;
if v_Count > 1 then
raise form_trigger_failure;
End If;
End;
</b>
Hope it will help you
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Sat Jun 10, 2006 7:11 am
by Kashif
This is not applicable.
Because we are not using Different ORACLE USERS for every Computer Operator. Single Oracle user is used on Different Computers which have same authorisation
is there no Any other Way Using WIN APIs?
as we can do this In Visual Basic easily.
Best Regards.
Muhammad Kashif
Posted: Sat Jun 10, 2006 7:18 am
by mirza_rehan
You create user for operator i mean you have any table for computer operator...... please tell
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Sat Jun 10, 2006 7:31 am
by mirza_rehan
Assalam-o-Alaikum
Kashif will you send me VB code or any sample VB form for this task???
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Tue Jun 13, 2006 5:56 am
by Kashif
[quote]You create user for operator i mean you have any table for computer operator...... please tell
<i><div align="right">Originally posted by mirza_rehan
Posted: Tue Jun 13, 2006 6:01 am
by Kashif
[quote]Assalam-o-Alaikum
Kashif will you send me VB code or any sample VB form for this task???
<i><div align="right">Originally posted by mirza_rehan
Posted: Tue Jun 13, 2006 6:13 am
by mirza_rehan
Assalam-o-Alaikum
Thanks alot for yours valueable reply.... please tell me about yours problem of Comm. OCX is it solved???
Once again thanks for yours cooperation.
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Tue Jun 13, 2006 6:17 am
by mirza_rehan
Its mean yours system have not any user authentication?????
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Tue Jun 13, 2006 9:40 am
by Kashif
[quote]Assalam-o-Alaikum
please tell me about yours problem of Comm. OCX is it solved???
<i>Originally posted by mirza_rehan
Posted: Tue Jun 13, 2006 9:43 am
by Kashif
[quote]Its mean yours system have not any user authentication?????
<i><div align="right">Originally posted by mirza_rehan
Posted: Tue Jun 13, 2006 9:45 am
by mirza_rehan
and what about user instances????
is your application authenticate the user ????? if yes so please tell me procedure......
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Tue Jun 13, 2006 9:51 am
by mirza_rehan
OOOhhhh no there is no varification about operator????
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Posted: Tue Jun 13, 2006 9:58 am
by Kashif
[quote]and what about user instances????
is your application authenticate the user ????? if yes so please tell me procedure......
<i><div align="right">Originally posted by mirza_rehan
Posted: Tue Jun 13, 2006 10:33 am
by Kashif
[quote]OOOhhhh no there is no varification about operator????
<i><div align="right">Originally posted by mirza_rehan