Rearranging things a bit ...
On Fri, 14 Nov 2008 19:05:36 -0000, rick <kanthasha@gmail.comwrote:
Quote:
On Nov 14, 12:56Â*pm, Serge Rielau <srie...@ca.ibm.comwrote:
Quote:
Quote:
>rick wrote:
>>
Quote:
we are using db2 8.2 on AIX
>>
Quote:
Issue is we have Â*group which allows all users in that group to read
and write on DB2 database.
But even though they have these permissions we want some tables to be
restricted. Meaning we dont want any users to delete any records from
a set of predefined tables. If they attempt to delete we want to
capture that user and the record he tried to delete.
>>
Quote:
Wat are the best ways??
>>
>Just revoke DELETE privileges for these tables from the users in
>questions.....
>>
>
I can do that but i want to capture who tried to delete
Quote:
Quote:
Quote:
I know db2 has audit facility , we dont want to use it for now.
Any particular reason? This is quite obviously the easiest way.
Cheers,
Dave.
