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

Hello Guys

I am developing one application in which there are two tables as follows
1)call_by_call_details(this table stores each call by call details) and tables columns are as follows
(call_id,caller_name,call_type,call_Date)

2)call_by_call_hist (this table stores monthwise history from call_by_call_details) and columns are as follows
(Rep_Month,call_type)

I have written the query that create history and put into call_by_call_hist on Every month end with the help of procedure and Job scheduling.

But after inserting the data into call_by_call_hist i want to lock this table till next insert,that means no one can change the data from hist table i.e.In this hist table only insert and fire a query is possible.

Could anyone give me the solution(possibly with explaination).

Thanks in advance

Sanjeev Received on Tue Jun 06 2006 - 05:03:31 CDT