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

Jagjeet Singh wrote:
> >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.
>
> Do you want to lock the table after loading till next job.
> or you want to block only updates.
>
> Regards,
> Js

Yes,I want to lock the table after loading till next job.

Actually i want to use this table for (insert and select) purpose means NO delete and update allowed.
but table should be in own schema means creator of this table is myself and i will have authority to only insert and select but NO delete and update.

please give me elaborative solution(Possibly Tutorial or link)

Thanks in advance Received on Wed Jun 07 2006 - 01:15:26 CDT