ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Rory's Stories Database Security Diagram
2
3
4
Projects
PortfolioPieces
Tags
PortfolioTags
CategoriesProductsFormats
PhysicalInventory
States
5
Database Admin
S I U D RS I U D RS I U D RS I U D RS I U D RS I U D RS I U D RS I U D RS I U D RPrivileges
6
CustomersSSSSSSSSS
S - Select (view)
7
Product Manager
S I U DS I U DS I U DS I U DS I U DS I U DS I U DS I U DS
I - Insert (create)
8
AccountantSSSSS U
U - Update (edit)
9
Customer Service
SSSSSSSS I U DS
D - Delete (remove)
10
R - References (create foreign keys)
11
12
ProductImages
Images
ProductOrders
OrdersCustomersCommissionsIncomesExpenses
13
Database Admin
S I U D RS I U D RS I U D RS I U D RS I U D RS I U D RS I U D RS I U D R
14
CustomersSSS* I*S* I*S* I* U* D*S* I*
*Privilege only applies to personal account
15
Product Manager
S I U DS I U DSSSSS I U DS I U D
16
AccountantSSSSSS
17
Customer Service
SSS I U DS I U DS I U DS I U D
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100