Multiple Instance of an Application.
Let me clear the confusion,
There are different ways to be authenticated. Few applications keep security tables and you create users in those tables with certain privs.
Another is to create users in database and then grant roles to them.
Now to be more specific the application you have will have separate database users for each user and you want to restrict the access of user. Say if scott has logged in once he can't login on another client?
or
you are want to restrict that only one copy of your application can be opened at any time on one machine?
Correct me if I am wrong so first we need to understand exactly the situation then we can suggest any workaround.
thanks
There are different ways to be authenticated. Few applications keep security tables and you create users in those tables with certain privs.
Another is to create users in database and then grant roles to them.
Now to be more specific the application you have will have separate database users for each user and you want to restrict the access of user. Say if scott has logged in once he can't login on another client?
or
you are want to restrict that only one copy of your application can be opened at any time on one machine?
Correct me if I am wrong so first we need to understand exactly the situation then we can suggest any workaround.
thanks
[quote]Let me clear the confusion,
Another is to create users in database and then grant roles to them.
Now to be more specific the application you have will have separate database users for each user and you want to restrict the access of user. Say if scott has logged in once he can't login on another client?
or
<b>you are want to restrict that only one copy of your application can be opened at any time on one machine? </b>
<i><div align="right">Originally posted by admin
Another is to create users in database and then grant roles to them.
Now to be more specific the application you have will have separate database users for each user and you want to restrict the access of user. Say if scott has logged in once he can't login on another client?
or
<b>you are want to restrict that only one copy of your application can be opened at any time on one machine? </b>
<i><div align="right">Originally posted by admin
So i think there is no Built-in Way for getting the results which is my Requirment.
So we have to find any Trick by saving the values in seprate table.
regarding, User Name, ComputerName and Apllication Name.
I will Share this if i will succeed in this.
Thanks to All of you who help me and Even any body little think about this Issue.
Thanks again
Best Regards.
Muhammad Kashif
So we have to find any Trick by saving the values in seprate table.
regarding, User Name, ComputerName and Apllication Name.
I will Share this if i will succeed in this.
Thanks to All of you who help me and Even any body little think about this Issue.
Thanks again
Best Regards.
Muhammad Kashif
The only issue you will have to clear records from that table when abnormal close of application will occure. Hope you got my point. This technique is normally used in web based applications like you may check at the botton of erpstuff.com where you have info the current online users. Ya it would be nice that you will share when you will have any solution. thanks
-
- Posts: 7
- Joined: Tue Apr 18, 2006 4:58 am
- Location: Pakistan
-
- Posts: 7
- Joined: Tue Apr 18, 2006 4:58 am
- Location: Pakistan
1) Attach a Libarary D2kwutil.Pll in ur form.
2) Add These Codes In W-N-F-I Trigger
Set_Window_Property(FORMS_MDI_WINDOW,Title,'TEST');
If Not Win_Api_Session.One_Session('TEST','IFRUN60.EXE','WINDOW',FALSE,WIN_API.D2K_WINDOW_CLASS,FALSE) Then
Message('Another Session Is Running...');
Exit_Form(No_Validate);
Else
Message('Another Session Is Not Running...');
End If;
Syntex :
Win_Api_Session.One_Session
(WindowTitle IN VARCHAR2,
ModuleName IN VARCHAR2,
MatchType IN VARCHAR2,
Activate IN BOOLEAN,
Class IN VARCHAR2 DEFAULT WIN_API.D2K_WINDOW_CLASS,
RaiseExceptions IN BOOLEAN DEFAULT FALSE);
Regard's
Fahed
2) Add These Codes In W-N-F-I Trigger
Set_Window_Property(FORMS_MDI_WINDOW,Title,'TEST');
If Not Win_Api_Session.One_Session('TEST','IFRUN60.EXE','WINDOW',FALSE,WIN_API.D2K_WINDOW_CLASS,FALSE) Then
Message('Another Session Is Running...');
Exit_Form(No_Validate);
Else
Message('Another Session Is Not Running...');
End If;
Syntex :
Win_Api_Session.One_Session
(WindowTitle IN VARCHAR2,
ModuleName IN VARCHAR2,
MatchType IN VARCHAR2,
Activate IN BOOLEAN,
Class IN VARCHAR2 DEFAULT WIN_API.D2K_WINDOW_CLASS,
RaiseExceptions IN BOOLEAN DEFAULT FALSE);
Regard's
Fahed
Today i tried the example given. it is Working fine.
but i have 150 PCs and most of them have Oracle system.
how should i Register the DLL file on each system one by one.
its too difficult and lengthy process. is there no other method except coping and registring the DLL file on evry PC
<font size="2"><font color="blue"><font face="Tahoma"><b>Best Regards.
Muhammad Kashif</b></font id="Tahoma"></font id="blue"></font id="size2">
but i have 150 PCs and most of them have Oracle system.
how should i Register the DLL file on each system one by one.
its too difficult and lengthy process. is there no other method except coping and registring the DLL file on evry PC
<font size="2"><font color="blue"><font face="Tahoma"><b>Best Regards.
Muhammad Kashif</b></font id="Tahoma"></font id="blue"></font id="size2">
Who is online
Users browsing this forum: No registered users and 2 guests