Subversion Repositories DevTools

Rev

Rev 53 | Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
51 mhunt 1 
insert into applications (app_id, application_name, acronym, is_running) values (9, 'Access Manager', 'xxx', 'Y')
2 
insert into applications (app_id, application_name, acronym, is_running) values (2, 'Release Manager', 'xxx', 'Y')
3 
insert into applications (app_id, application_name, acronym, is_running) values (1, 'Deployment Manager', 'xxx', 'Y')
4 
insert into applications (app_id, application_name, acronym, is_running) values (10, 'Production Manager', 'xxx', 'Y')
5 
 
6 
insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev')
7 
 
8 
either
9 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', chr(to_number('8e','XX'))||chr(to_number('ec','XX'))||chr(to_number('1e','XX'))||chr(to_number('97','XX'))||chr(to_number('ac','XX'))||chr(to_number('60','XX'))||chr(to_number('2d','XX'))||chr(to_number('32','XX'))||chr(to_number('28','XX'))||chr(to_number('ba','XX'))||chr(to_number('d3','XX'))||chr(to_number('3b','XX'))||chr(to_number('61','XX'))||chr(to_number('ef','XX'))||chr(to_number('ea','XX'))||chr(to_number('ae','XX')))
10 
 
11 
or
12 
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ))
13 
 
14 
insert into user_applications (user_id, app_id) values (1, 9)
15 
insert into user_applications (user_id, app_id) values (2, 2)
16 
insert into user_applications (user_id, app_id) values (2, 1)
17 
insert into user_applications (user_id, app_id) values (2, 10)
18 
 
19 
insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE')
20 
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE')
21 
 
22 
insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator')
23 
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester')
24 
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester')
25 
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList')
26 
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects')
27 
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference')
28 
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration')
29 
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline')
30 
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage')
31 
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage')
32 
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects')
33 
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild')
34 
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference')
35 
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode')
36 
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending')
37 
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed')
38 
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive')
39 
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents')
40 
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease')
41 
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease')
42 
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease')
43 
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode')
44 
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues')
45 
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject')
46 
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion')
47 
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies')
48 
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues')
49 
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode')
50 
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage')
51 
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild')
52 
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage')
53 
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch')
54 
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager')
55 
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB')
56 
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage')
57 
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView')
58 
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending')
59 
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues')
60 
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch')
61 
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager')
62 
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester')
63 
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion')
64 
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE')
65 
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco')
66 
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService')
67 
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease')
68 
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible')
69 
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment')
70 
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration')
71 
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest')
72 
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct')
73 
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy')
74 
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease')
75 
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage')
76 
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage')
77 
 
78 
insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer')
79 
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer')
80 
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer')
81 
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer')
82 
 
83 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
84 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
85 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
86 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
87 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 1, 'Y');
88 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 2, 'Y');
89 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 1, 'Y');
90 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 2, 'Y');
91 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 1, 'Y');
92 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 2, 'Y');
93 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 1, 'Y');
94 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 2, 'Y');
95 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 1, 'Y');
96 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 2, 'Y');
97 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 1, 'Y');
98 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 2, 'Y');
99 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 1, 'Y');
100 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 2, 'Y');
101 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 1, 'Y');
102 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 2, 'Y');
103 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 1, 'Y');
104 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 2, 'Y');
105 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 1, 'Y');
106 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 2, 'Y');
107 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 1, 'Y');
108 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 2, 'Y');
109 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 1, 'Y');
110 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 2, 'Y');
111 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 1, 'Y');
112 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 2, 'Y');
113 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 1, 'Y');
114 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 2, 'Y');
115 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 1, 'Y');
116 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 2, 'Y');
117 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 1, 'Y');
118 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 2, 'Y');
119 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 1, 'Y');
120 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 2, 'Y');
121 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 1, 'Y');
122 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 2, 'Y');
123 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 1, 'Y');
124 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 2, 'Y');
125 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 1, 'Y');
126 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 2, 'Y');
127 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 1, 'Y');
128 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 2, 'Y');
129 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 1, 'Y');
130 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 2, 'Y');
131 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 1, 'Y');
132 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 2, 'Y');
133 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 1, 'Y');
134 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 2, 'Y');
135 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 1, 'Y');
136 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 2, 'Y');
137 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 1, 'Y');
138 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 2, 'Y');
139 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 1, 'Y');
140 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 2, 'Y');
141 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 1, 'Y');
142 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 2, 'Y');
143 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 1, 'Y');
144 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 2, 'Y');
145 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 1, 'Y');
146 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 2, 'Y');
147 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 1, 'Y');
148 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 2, 'Y');
149 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 1, 'Y');
150 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 2, 'Y');
151 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 1, 'Y');
152 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 2, 'Y');
153 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 1, 'Y');
154 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 2, 'Y');
155 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 1, 'Y');
156 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 2, 'Y');
157 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 1, 'Y');
158 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 2, 'Y');
159 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 1, 'Y');
160 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 2, 'Y');
161 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 1, 'Y');
162 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 2, 'Y');
163 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 1, 'Y');
164 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 2, 'Y');
165 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 1, 'Y');
166 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 2, 'Y');
167 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 1, 'Y');
168 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 2, 'Y');
169 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 1, 'Y');
170 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 2, 'Y');
171 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 1, 'Y');
172 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 2, 'Y');
173 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 1, 'Y');
174 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 2, 'Y');
175 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 1, 'Y');
176 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 2, 'Y');
177 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 1, 'Y');
178 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 2, 'Y');
179 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 1, 'Y');
180 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 2, 'Y');
181 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 1, 'Y');
182 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 2, 'Y');
183 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 1, 'Y');
184 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 2, 'Y');
185 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 1, 'Y');
186 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 2, 'Y');
187 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 1, 'Y');
188 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 2, 'Y');
189 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 1, 'Y');
190 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 2, 'Y');
191 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 1, 'Y');
192 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 2, 'Y');
193 
 
194 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 1, 'Y');
195 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 2, 'Y');
196 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 1, 'Y');
197 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 2, 'Y');
198 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 1, 'Y');
199 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 2, 'Y');
200 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 1, 'Y');
201 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 2, 'Y');
202 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 1, 'Y');
203 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 2, 'Y');
204 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 1, 'Y');
205 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 2, 'Y');
206 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 1, 'Y');
207 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 2, 'Y');
208 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 1, 'Y');
209 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 2, 'Y');
210 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 1, 'Y');
211 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 2, 'Y');
212 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 1, 'Y');
213 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 2, 'Y');
214 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 1, 'Y');
215 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 2, 'Y');
216 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 1, 'Y');
217 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 2, 'Y');
218 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 1, 'Y');
219 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 2, 'Y');
220 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 1, 'Y');
221 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 2, 'Y');
222 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 1, 'Y');
223 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 2, 'Y');
224 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 1, 'Y');
225 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 2, 'Y');
226 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 1, 'Y');
227 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 2, 'Y');
228 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 1, 'Y');
229 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 2, 'Y');
230 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 1, 'Y');
231 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 2, 'Y');
232 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 1, 'Y');
233 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 2, 'Y');
234 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 1, 'Y');
235 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 2, 'Y');
236 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 1, 'Y');
237 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 2, 'Y');
238 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 1, 'Y');
239 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 2, 'Y');
240 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 1, 'Y');
241 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 2, 'Y');
242 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 1, 'Y');
243 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 2, 'Y');
244 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 1, 'Y');
245 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 2, 'Y');
246 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 1, 'Y');
247 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 2, 'Y');
248 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 1, 'Y');
249 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 2, 'Y');
250 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 1, 'Y');
251 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 2, 'Y');
252 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 1, 'Y');
253 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 2, 'Y');
254 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 1, 'Y');
255 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 2, 'Y');
256 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 1, 'Y');
257 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 2, 'Y');
258 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 1, 'Y');
259 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 2, 'Y');
260 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 1, 'Y');
261 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 2, 'Y');
262 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 1, 'Y');
263 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 2, 'Y');
264 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 1, 'Y');
265 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 2, 'Y');
266 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 1, 'Y');
267 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 2, 'Y');
268 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 1, 'Y');
269 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 2, 'Y');
270 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 1, 'Y');
271 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 2, 'Y');
272 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 1, 'Y');
273 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 2, 'Y');
274 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 1, 'Y');
275 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 2, 'Y');
276 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 1, 'Y');
277 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 2, 'Y');
278 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 1, 'Y');
279 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 2, 'Y');
280 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 1, 'Y');
281 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 2, 'Y');
282 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 1, 'Y');
283 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 2, 'Y');
284 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 1, 'Y');
285 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 2, 'Y');
286 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 1, 'Y');
287 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 2, 'Y');
288 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 1, 'Y');
289 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 2, 'Y');
290 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 1, 'Y');
291 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 2, 'Y');
292 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 1, 'Y');
293 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 2, 'Y');
294 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 1, 'Y');
295 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 2, 'Y');
296 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 1, 'Y');
297 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 2, 'Y');
298 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 1, 'Y');
299 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 2, 'Y');
300 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 1, 'Y');
301 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 2, 'Y');
302 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 1, 'Y');
303 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 2, 'Y');
304 
 
305 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 1, 'Y');
306 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 2, 'Y');
307 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 1, 'Y');
308 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 2, 'Y');
309 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 1, 'Y');
310 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 2, 'Y');
311 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 1, 'Y');
312 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 2, 'Y');
313 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 1, 'Y');
314 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 2, 'Y');
315 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 1, 'Y');
316 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 2, 'Y');
317 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 1, 'Y');
318 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 2, 'Y');
319 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 1, 'Y');
320 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 2, 'Y');
321 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 1, 'Y');
322 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 2, 'Y');
323 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 1, 'Y');
324 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 2, 'Y');
325 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 1, 'Y');
326 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 2, 'Y');
327 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 1, 'Y');
328 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 2, 'Y');
329 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 1, 'Y');
330 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 2, 'Y');
331 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 1, 'Y');
332 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 2, 'Y');
333 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 1, 'Y');
334 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 2, 'Y');
335 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 1, 'Y');
336 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 2, 'Y');
337 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 1, 'Y');
338 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 2, 'Y');
339 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 1, 'Y');
340 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 2, 'Y');
341 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 1, 'Y');
342 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 2, 'Y');
343 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 1, 'Y');
344 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 2, 'Y');
345 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 1, 'Y');
346 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 2, 'Y');
347 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 1, 'Y');
348 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 2, 'Y');
349 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 1, 'Y');
350 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 2, 'Y');
351 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 1, 'Y');
352 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 2, 'Y');
353 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 1, 'Y');
354 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 2, 'Y');
355 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 1, 'Y');
356 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 2, 'Y');
357 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 1, 'Y');
358 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 2, 'Y');
359 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 1, 'Y');
360 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 2, 'Y');
361 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 1, 'Y');
362 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 2, 'Y');
363 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 1, 'Y');
364 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 2, 'Y');
365 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 1, 'Y');
366 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 2, 'Y');
367 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 1, 'Y');
368 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 2, 'Y');
369 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 1, 'Y');
370 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 2, 'Y');
371 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 1, 'Y');
372 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 2, 'Y');
373 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 1, 'Y');
374 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 2, 'Y');
375 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 1, 'Y');
376 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 2, 'Y');
377 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 1, 'Y');
378 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 2, 'Y');
379 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 1, 'Y');
380 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 2, 'Y');
381 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 1, 'Y');
382 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 2, 'Y');
383 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 1, 'Y');
384 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 2, 'Y');
385 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 1, 'Y');
386 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 2, 'Y');
387 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 1, 'Y');
388 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 2, 'Y');
389 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 1, 'Y');
390 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 2, 'Y');
391 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 1, 'Y');
392 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 2, 'Y');
393 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 1, 'Y');
394 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 2, 'Y');
395 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 1, 'Y');
396 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 2, 'Y');
397 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 1, 'Y');
398 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 2, 'Y');
399 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 1, 'Y');
400 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 2, 'Y');
401 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 1, 'Y');
402 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 2, 'Y');
403 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 1, 'Y');
404 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 2, 'Y');
405 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 1, 'Y');
406 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 2, 'Y');
407 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 1, 'Y');
408 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 2, 'Y');
409 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 1, 'Y');
410 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 2, 'Y');
411 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 1, 'Y');
412 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 2, 'Y');
413 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 1, 'Y');
414 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 2, 'Y');
415 
 
416 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 1, 'Y');
417 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 2, 'Y');
418 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 1, 'Y');
419 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 2, 'Y');
420 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 1, 'Y');
421 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 2, 'Y');
422 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 1, 'Y');
423 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 2, 'Y');
424 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 1, 'Y');
425 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 2, 'Y');
426 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 1, 'Y');
427 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 2, 'Y');
428 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 1, 'Y');
429 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 2, 'Y');
430 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 1, 'Y');
431 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 2, 'Y');
432 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 1, 'Y');
433 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 2, 'Y');
434 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 1, 'Y');
435 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 2, 'Y');
436 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 1, 'Y');
437 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 2, 'Y');
438 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 1, 'Y');
439 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 2, 'Y');
440 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 1, 'Y');
441 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 2, 'Y');
442 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 1, 'Y');
443 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 2, 'Y');
444 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 1, 'Y');
445 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 2, 'Y');
446 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 1, 'Y');
447 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 2, 'Y');
448 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 1, 'Y');
449 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 2, 'Y');
450 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 1, 'Y');
451 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 2, 'Y');
452 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 1, 'Y');
453 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 2, 'Y');
454 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 1, 'Y');
455 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 2, 'Y');
456 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 1, 'Y');
457 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 2, 'Y');
458 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 1, 'Y');
459 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 2, 'Y');
460 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 1, 'Y');
461 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 2, 'Y');
462 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 1, 'Y');
463 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 2, 'Y');
464 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 1, 'Y');
465 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 2, 'Y');
466 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 1, 'Y');
467 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 2, 'Y');
468 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 1, 'Y');
469 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 2, 'Y');
470 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 1, 'Y');
471 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 2, 'Y');
472 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 1, 'Y');
473 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 2, 'Y');
474 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 1, 'Y');
475 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 2, 'Y');
476 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 1, 'Y');
477 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 2, 'Y');
478 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 1, 'Y');
479 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 2, 'Y');
480 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 1, 'Y');
481 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 2, 'Y');
482 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 1, 'Y');
483 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 2, 'Y');
484 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 1, 'Y');
485 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 2, 'Y');
486 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 1, 'Y');
487 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 2, 'Y');
488 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 1, 'Y');
489 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 2, 'Y');
490 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 1, 'Y');
491 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 2, 'Y');
492 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 1, 'Y');
493 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 2, 'Y');
494 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 1, 'Y');
495 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 2, 'Y');
496 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 1, 'Y');
497 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 2, 'Y');
498 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 1, 'Y');
499 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 2, 'Y');
500 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 1, 'Y');
501 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 2, 'Y');
502 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 1, 'Y');
503 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 2, 'Y');
504 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 1, 'Y');
505 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 2, 'Y');
506 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 1, 'Y');
507 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 2, 'Y');
508 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 1, 'Y');
509 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 2, 'Y');
510 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 1, 'Y');
511 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 2, 'Y');
512 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 1, 'Y');
513 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 2, 'Y');
514 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 1, 'Y');
515 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 2, 'Y');
516 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 1, 'Y');
517 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 2, 'Y');
518 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 1, 'Y');
519 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 2, 'Y');
520 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 1, 'Y');
521 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 2, 'Y');
522 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 1, 'Y');
523 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 2, 'Y');
524 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 1, 'Y');
525 
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 2, 'Y');
526 
 
527 
insert into user_roles (user_id, role_id) values (1, 1);
528 
insert into user_roles (user_id, role_id) values (1, 2);
529 
insert into user_roles (user_id, role_id) values (1, 3);
530 
insert into user_roles (user_id, role_id) values (1, 4);
531 
insert into user_roles (user_id, role_id) values (2, 1);
532 
insert into user_roles (user_id, role_id) values (2, 2);
533 
insert into user_roles (user_id, role_id) values (2, 3);
534 
insert into user_roles (user_id, role_id) values (2, 4);