Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Timebound access to system

 
Karan Saxena
Greenhorn
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
day=wednesday
accesstimefrom=02:00
accesstimeto=04:00

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
Java

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic