-
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
-
edit product_user_profile
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
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|