Multiple Instance of an Application.

To discuss Oracle Forms & Reports related technical issues.
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Multiple Instance of an Application.

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

[quote]Assalam-o-Alaikum

please tell me about yours problem of Comm. OCX is it solved???

<i>Originally posted by mirza_rehan
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

[quote]Its mean yours system have not any user authentication?????

<i><div align="right">Originally posted by mirza_rehan
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post 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
Kashif
Posts: 137
Joined: Wed Apr 26, 2006 5:57 am
Location: Pakistan
Contact:

Post by Kashif »

[quote]OOOhhhh no there is no varification about operator????

<i><div align="right">Originally posted by mirza_rehan
Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests