• Post Reply Bookmark Topic Watch Topic
  • New Topic

Timebound access to system  RSS feed

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

Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!