Re: How to LOCK TABLE/READ ONLY table in own schema after data insertion

>>You would need to two things
>>1 set up a table with 'closed out' periods
>>2 create a view on top on the hist table, which will join the hist
>>table and the table you just created, allowing to view only data for
>>'open' periods. The view has to be created 'With check option'
>>3 The inserting program (or no one) doesn't get insert privilege on
>>the table, it only gets insert privilege on the view
>>4 As soon as the insert program gets out of boundaries, the insert
>>will fail.

I have read your solution But sorry to say that it is confusing for me. I am confuse with
 >set up a table with 'closed out' periods (Please clear this point more clearly with example if possible or link)  

WOULD YOU PLEASE MAKE IT MORE ELABORATIVE ? Its urgent. Received on Wed Jun 07 2006 - 03:58:22 CDT