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

On 6 Jun 2006 23:15:26 -0700, sanjeev_atvankar_at_hotmail.com wrote:

>
>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

Did you actually read my solution? What's wrong it?

--
Sybrand Bakker, Senior Oracle DBA