Multiple Instance of an Application.
Multiple Instance of an Application.
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
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
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
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 1 guest