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.
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
Click Here to Expand Forum to Full Width