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)
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.
Joined: 06 Jul 2010 Posts: 650 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.