Access Policity Design

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vitamin - 16 Dec 2003 07:43 GMT

Does any one have some db design about access right?

for example:

Role | type A | type B | type C | type D | type E |
Action |
------------+---------------------------------------------------------
Task A | Yes | No | No | yes | No |
Task B | Yes | Yes | Yes | no | no |
Task C | No | No | No | No | No |
Task D | Yes | Yes | Yes | Yes | Yes |

Reply to this Message

Michel Walsh - 16 Dec 2003 13:49 GMT

Hi,

Yep.

Rights ' tableName
Action, Type ' field name

and, as record, just enumerate those that are "yes". I.E.: if the pair
(Action, Type) is not in the table, then the right is NO ( the role type
cannot perform the action task).

If 0=DCount("*", "Rights", "Action=""" & Action & """ AND type=" &
type & """" ) Then
... no access...
Else
... access...
End If

Hoping it may help,
Vanderghast, Access MVP

> Does any one have some db design about access right?
>
[quoted text clipped - 7 lines]
> Task C | No | No | No | No | No |
> Task D | Yes | Yes | Yes | Yes | Yes |

Reply to this Message