Limiting access to a view based on time frame

• arthur comegno

  SSC Veteran

  Points: 285

  More actions

  June 14, 2007 at 7:54 am

  #62064

  Is is possible to grant Select right to a view, and then limit that right to a time frame, such as 9 AM to noon? 

  Thanks,

  Arthur

   

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  June 14, 2007 at 8:02 am

  #712940

  Arthur

  Not as far as I know.  Although you could change the view to a stored procedure, and put some conditional logic in that.

  John

• Karl Hewlett

  Mr or Mrs. 500

  Points: 528

  More actions

  June 14, 2007 at 8:47 pm

  #713109

  Hi Its 2.45 pm here, I get results from klh1 and nothing from klh2.  The trick is that each predicate must be true, therefore we can limit by time of day

  create view klh1 as

   select *

   from contact_details

   where username like 'a%'

     and  datepart(hh, getdate()) between 12 and 15

  create view klh2 as

   select *

   from contact_details

   where username like 'a%'

     and  datepart(hh, getdate()) between 1 and 5

   

  Regards

  Karl

• arthur comegno

  SSC Veteran

  Points: 285

  More actions

  June 15, 2007 at 11:04 am

  #713334

  Thank you, both of you.  Both solutions offer good possibilities. 

  "User", not "Username" works for me.  Using datepart() is very simple and works nicely. 

   

  Arthur