Access Policity Design

  • Thread starter Thread starter Vitamin
  • Start date Start date
V

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 |
 
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
 
Back
Top