I am developing a client server application, Oracle as Backend & Developer 2000 (Oracle forms) as Front end. I want to restrict this application to a single user. This application has 2 usernames (say, x & y).
I have 2 methods to achieve my requirement.
1) By Maintaining temporary table with Username as a column.
2) verify system session information (for whole database) using V$Session.
First method is not recommended (I can keep it as lasts solution !!). Second method is not safer as these logins will have full information about complete database.
Is there any optimized method for my requirement ??? Please reply as early as possible .