Hi Friends,

My Problem is ..

I want to Restrict Table Level Updates on a particular table. I tried to provide this option by Writing trigger on that table. But i did not succeed.

To elaborate, Whenever an Update Occurs with out "Where Clause" i have to provide the mechanism to reject that action. At the Same time i should allow if Updates happens with where Clause.

Atleast I have to restrict the Updates which affects on all the records which are existed on this table.

i will be greatful if i can get a way to this problem.

Regards,
Sekhar