Databases Reference
In-Depth Information
Figure 11-13
Managers can view and modify:
CUSTOMER
CUSTOMEREMPLOYEE
SALESPERSON
Sam
Alice
George
SalesManagers can view and modify:
CUSTOMER
ORDERHEAD
ORDERDETAIL
SALES
Sam
Ed
Marta
Sales can view:
CUSTOMER
Sales can modify:
ORDERHEAD
ORDERDETAIL
Marta
Jack
Andy
Sample roles.
Notice that Marta is a member of the Sales and SalesManagers roles. The
permissions granted through roles are additive, so that means she can view and
modify CUSTOMER, ORDERHEAD, ORDERDETAIL, and SALES. She would
have the same permission if she belonged to SalesManagers only.
