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