have to restrict table level updates
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: have to restrict table level updates

  1. #1
    Join Date
    Jan 2002
    Posts
    78
    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

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    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
  •  



Click Here to Expand Forum to Full Width