• Post Reply Bookmark Topic Watch Topic
  • New Topic

Timebound access to system

Karan Saxena
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually I have got a situation ,and I am looking for guidance .. The thing is I have got a table which contains entries for days and time at which a user can access the system .

The columns are in this way :-

Userid day accesstimefrom accesstimeto

now I am looking for a way by which I can ensure that for a particular user who has got entry in the table ,the user should be able to access the system at the time and day specified in the table upto the value in accesstimeto column of my table .for if

userid =1

then user with userid =1 can access the system only at wednesday at 02:00 in the night till 04:00 i.e for 2 hrs

Please provide a way how can I achieve this ,

I am using
Jboss 7.1 as server
oracle 10g DB

What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!