473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Soft permissions?

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?

Paul
Nov 12 '05 #1
3 1376
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.

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?

Paul


Nov 12 '05 #2
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
Nov 12 '05 #3
pa**@atom.sbrk.co.uk <pa**@atom.sbrk.co.uk> wrote:
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.


Maybe you could rename the table and then create an appropriate view with
the original table name to implement the restriction. Then you would not
get any error, but you would not see any "illegal" access attempt either.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

383
by: John Bailo | last post by:
The war of the OSes was won a long time ago. Unix has always been, and will continue to be, the Server OS in the form of Linux. Microsoft struggled mightily to win that battle -- creating a...
6
by: Mark | last post by:
Hi, My page has a table with many columns such that the right-side of the table gets chopped off when printed. I specify a table width of 100%, but otherwise no cell dimensions are specified. ...
1
by: com | last post by:
Extreme Web Reports 2005 - Soft30.com The wizard scans the specified MS Access database and records information such as report names, parameters and subqueries. ......
4
by: tbatwork828 | last post by:
Related to my other post on Graphics.FillRectangle and a lot of page faults caused by this call... We determine that when Control.DoubleBuffer=true to avoid the flicker effect,...
0
by: paulvz882 | last post by:
comprimes de acomplia en France commander acomplia en ligne aucune prescription acomplia canada soft en ligne +++ PERTE DE POIDS +++ PERTE DE POIDS +++ PERTE DE POIDS +++ + ACHETER DU ACOMPLIA...
0
by: hessman1234 | last post by:
achat lipitor canada bon marche achat lipitor au rabais en ligne sans prescription acheter lipitor le plus bon marche un Achat de achat lipitor us usa avec livraison achat lipitor belgique soft...
0
by: jkjtjktjktjhktjk | last post by:
acheter du acomplia cinq acomplia par email PERTE DE POIDS en France acomplia canada soft en ligne acomplia belgique acomplia belgique bon marche acheter du acomplia en ligne sur internet +++...
0
by: gfjhrsghhdgh | last post by:
acomplia belgique soft generique commander comprime de acomplia canada achat acomplia canada Pro commander acomplia us usa soft acomplia suisse le plus bon marche citrate de Rimonabant soft en...
0
by: sdgvfwe | last post by:
achat ampicillin canada a vendre comprimes de acheter ampicillin en France bon marche achat acheter ampicillin canada acheter ampicillin canada en ligne sur internet acheter ampicillin canada soft...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.