Access Policity Design

[Vitamin]

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 |

 

[Michel Walsh]

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