In article <bn**********@hanover.torolab.ibm.com>, Blair Adamache wrote:
pa**@atom.sbrk.co.uk wrote: Is there any way to grant some sort of advisory or "soft"
permissions to a table such that only warnings would be
generated if the permissions were violated rather than
preventing the access altogether?
Not that I know of - you could use triggers to write the warnings to a
table for "illegal" inserts/updates/deletes.
You could also use the audit facility (db2audit) to track illicit
access, and perhaps interpret the contents of the audit file to send
warnings to users.
Thanks for that. I imagined that it was possible to do with triggers
and thought that someone might've already implemented something
similar. The auditing is also another after the fact alternative
I could try.
The reason to do this is to add some restrictions to an existing
application but I'd like to figure out the impact before committing
to it.
Cheers,
Paul