ERPstuff - Oracle EBS Community

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

You are Exactly right.

This is the Actual Situation and Requirement.

Thanks for Clearing More Descriptive.

Best Regards.

Muhammad Kashif

Is there no Way of Application Restriction like My requirment?




Best Regards.

Muhammad Kashif

Pl let us know exactly which requirement as I have provided different options. 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

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

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

You should use D2kwutil.pll Library Function Win_Api_Session.One_Session to restrict the user for Open more then one instance of Application. If u need example I will post it.

Reagrd's
Fahed Akhter

[quote]You should use D2kwutil.pll Library Function Win_Api_Session.One_Session to restrict the user for Open more then one instance of Application. If u need example I will post it.

Reagrd's
Fahed Akhter

<i><div align="right">Originally posted by fahedakhter

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

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">