Re: SIGNAL ON DELETE AND CAPTURE

#1 November 16th, 2008, 12:15 AM

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:

>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:

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.

#2 November 17th, 2008, 08:05 PM

On Nov 15, 7:07*pm, "Dave Hughes" <d...@waveform.plus.comwrote:

Quote:

Rearranging things a bit ...
>
>
>
>
>
On Fri, 14 Nov 2008 19:05:36 -0000, rick <kantha...@gmail.comwrote:

Quote:

On Nov 14, 12:56*pm, Serge Rielau <srie...@ca.ibm.comwrote:

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??

>

Quote:

Just revoke DELETE privileges for these tables from the users in
questions.....

>

Quote:

I can do that but i want to capture who tried to delete

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.- Hide quoted text -
>
- Show quoted text -

Reason is we want to know why and who attempted to delete.

#3 November 17th, 2008, 11:35 PM

rick wrote:

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.
>>

Reason is we want to know why and who attempted to delete.

Why? I don't think your trigger would tell you why.

But the audit log could certainly capture failed attempts to delete
from the table, which would tell you *who* is trying to delete records.

Re: SIGNAL ON DELETE AND CAPTURE

re: Re: SIGNAL ON DELETE AND CAPTURE

re: Re: SIGNAL ON DELETE AND CAPTURE

/bytes/development

/bytes/it

/bytes/about