View previous topic :: View next topic
|
Author |
Message |
Dineshec
New User
Joined: 12 Jan 2013 Posts: 2 Location: INDIA
|
|
|
|
Hi All ,
I have a typical requirement for table security issue. If we are going to update a table ,think like 100 changes will take place due to the query i used , but my requirement is i should have a check like the table should allow us to update /delete only 10 changes at single stretch. ( I want to have this condition at delaration level of table not at writing a query for update process) |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
Quote: |
I have a typical requirement for table security issue. |
not typical just warped/inane
Quote: |
( I want to have this condition at delaration level of table not at writing a query for update process) |
unfortunately not always You can have what You want |
|
Back to top |
|
|
Dineshec
New User
Joined: 12 Jan 2013 Posts: 2 Location: INDIA
|
|
|
|
Are you telling me its not possible!!! I am trying my luck with some of options like UPDATE on RESTRICT , OPTIMIZE in DB2. The main problem is i can use them in query level execution not at DBA Level. And also The aim is to restrict the updation of table rows to some limit when we run a SPUFI. |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
Well, I suppose you could use the DB2 resource governor to severely restrict your queries so that they fail after a very small number of updates. But that would be very imprecise and would frustrate your users. Not recommended.
Or, stand behind every user who has update authority and rap them with a cricket bat whenever they compose an update statement that might hit more than 10 rows.
Or, revoke update access from <everyone>. Only allow updates via a program / plan that enforces your restriction. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Quote: |
I'm going to give a chainsaw to all my employees.
How do I restrict the chainsaw so it can only cut straws? |
|
|
Back to top |
|
|
|