have to restrict table level updates

[Sekhar]

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

[anandkl]

you can edit product_user_profile which the sql*plus will query when a user starts a session.You can edit this table for restricting users in performing any ddl or dml activites against the database objects

cheese
anandkl