FIGURE 1: Security Decision Matrix
Authors Table Permissions
Roles Select Insert Update Delete References
InfoSystems X X X X X
Developers X X X X X
HumanResources X X X X
Managers X X X X
EditorialStaff X
Production X
MarketingSales X
Titles Table Permissions
Roles Select Insert Update Delete References
InfoSystems X X X X X
Developers X X X X X
HumanResources X
Managers X X X X
EditorialStaff X X X X
Production X
MarketingSales X
TitleAuthor Table Permissions
Roles Select Insert Update Delete References
InfoSystems X X X X X
Developers X X X X X
HumanResources X
Managers X X X X
EditorialStaff X X X X
Production X
MarketingSales X