A quick general question that a subscriber may be able to answer…

In terms of access permissions, what would be the order in terms of increasing priority - add,
delete, change?

This doesn't just apply to databases, but database level is a good start.

On Fri, 11 Mar 2011 12:23:22 +0000, gargoyle60 <gargoyle60 (AT) example (DOT) invalid> wrote:

Forgive me, I should elaborate.

I am trying to define some data access rules, starting with the least access permissions, increasing
to the highest level of access control.
This can be crudely represented something like this...

0 - access denied
1 - read/view only
2 - read/view & delete
3 - read/view & add
4 - read/view & add & delete
5 - read/view & change
6 - read/view & change & delete
7 - read/view & change & add
8 - full access (read/view & change & add & delete)

NB. the absence of an entry means no access allowed, so no need to explicitly include a 0 entry.

On 2011-03-11 17:02, gargoyle60 wrote:

I don't think there is a strict order that applies to all possible
situations. For example, I assume that read is more restrictive than add
when it comes to hospital journals.


/Lennart

On Fri, 11 Mar 2011 18:25:09 +0100, Lennart Jonsson <erik.lennart.jonsson (AT) gmail (DOT) com> wrote:

Yes, I see your point. I realise that it's probably a subjective question depending on scenario.