Subversion Repositories DevTools

Rev

Rev 53 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

insert into applications (app_id, application_name, acronym, is_running) values (9, 'Access Manager', 'xxx', 'Y')
insert into applications (app_id, application_name, acronym, is_running) values (2, 'Release Manager', 'xxx', 'Y')
insert into applications (app_id, application_name, acronym, is_running) values (1, 'Deployment Manager', 'xxx', 'Y')
insert into applications (app_id, application_name, acronym, is_running) values (10, 'Production Manager', 'xxx', 'Y')

insert into users (user_id, full_name, user_name, user_password) values (1, 'dev', 'dev1', 'dev')

either
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')))

or
insert into users (user_id, full_name, user_name, user_password) values (2, 'dev', 'dev2', PK_AMUTILS.GET_HASH( 'dev' ))

insert into user_applications (user_id, app_id) values (1, 9)
insert into user_applications (user_id, app_id) values (2, 2)
insert into user_applications (user_id, app_id) values (2, 1)
insert into user_applications (user_id, app_id) values (2, 10)

insert into permission_types (perm_id, perm_name) values (1, 'enumVISIBLE')
insert into permission_types (perm_id, perm_name) values (2, 'enumACTIVE')

insert into control_objects (obj_id, app_id, obj_name) values (1, 1, 'pmoCreator')
insert into control_objects (obj_id, app_id, obj_name) values (2, 1, 'pmoTester')
insert into control_objects (obj_id, app_id, obj_name) values (3, 1, 'pmoExternalTester')
insert into control_objects (obj_id, app_id, obj_name) values (4, 1, 'oProjectList')
insert into control_objects (obj_id, app_id, obj_name) values (5, 1, 'EditPackageInExternalProjects')
insert into control_objects (obj_id, app_id, obj_name) values (6, 1, 'AddReleaseReference')
insert into control_objects (obj_id, app_id, obj_name) values (7, 1, 'pageApplicationConfiguration')
insert into control_objects (obj_id, app_id, obj_name) values (8, 1, 'onApplicationOffline')
insert into control_objects (obj_id, app_id, obj_name) values (10, 1, 'UnlockPackage')
insert into control_objects (obj_id, app_id, obj_name) values (11, 1, 'DestroyPackage')
insert into control_objects (obj_id, app_id, obj_name) values (12, 1, 'EditProjects')
insert into control_objects (obj_id, app_id, obj_name) values (13, 1, 'ApproveForAutoBuild')
insert into control_objects (obj_id, app_id, obj_name) values (14, 1, 'RemoveReleaseReference')
insert into control_objects (obj_id, app_id, obj_name) values (15, 1, 'ApprovePackageReleaseForRestrictiveMode')
insert into control_objects (obj_id, app_id, obj_name) values (16, 1, 'RejectPackageFromPending')
insert into control_objects (obj_id, app_id, obj_name) values (17, 1, 'ChangeModeFromClosed')
insert into control_objects (obj_id, app_id, obj_name) values (18, 1, 'ChangeModeFromRestrictive')
insert into control_objects (obj_id, app_id, obj_name) values (19, 1, 'CloneReleaseContents')
insert into control_objects (obj_id, app_id, obj_name) values (20, 1, 'DestroyRelease')
insert into control_objects (obj_id, app_id, obj_name) values (21, 1, 'CreateNewRelease')
insert into control_objects (obj_id, app_id, obj_name) values (22, 1, 'MergeRelease')
insert into control_objects (obj_id, app_id, obj_name) values (23, 1, 'AlterReleaseContentsInRestrictiveMode')
insert into control_objects (obj_id, app_id, obj_name) values (24, 1, 'ImportOpenIssues')
insert into control_objects (obj_id, app_id, obj_name) values (25, 1, 'CreateNewProject')
insert into control_objects (obj_id, app_id, obj_name) values (26, 1, 'ChangePreviousVersion')
insert into control_objects (obj_id, app_id, obj_name) values (27, 1, 'ImportDependencies')
insert into control_objects (obj_id, app_id, obj_name) values (28, 1, 'ImportVasttrafikIssues')
insert into control_objects (obj_id, app_id, obj_name) values (29, 1, 'AddDeletePackageInRestrictiveMode')
insert into control_objects (obj_id, app_id, obj_name) values (30, 1, 'RemovePackage')
insert into control_objects (obj_id, app_id, obj_name) values (31, 1, 'ApproveForManualBuild')
insert into control_objects (obj_id, app_id, obj_name) values (32, 1, 'RipplePackage')
insert into control_objects (obj_id, app_id, obj_name) values (33, 1, 'ReleasePatch')
insert into control_objects (obj_id, app_id, obj_name) values (34, 1, 'mergeManager')
insert into control_objects (obj_id, app_id, obj_name) values (35, 1, 'MergeReleaseForCCB')
insert into control_objects (obj_id, app_id, obj_name) values (36, 1, 'DeprecatePackage')
insert into control_objects (obj_id, app_id, obj_name) values (37, 1, 'AdminView')
insert into control_objects (obj_id, app_id, obj_name) values (38, 1, 'EditReleaseNotesInPending')
insert into control_objects (obj_id, app_id, obj_name) values (39, 1, 'DeleteOutstandingIssues')
insert into control_objects (obj_id, app_id, obj_name) values (40, 1, 'UnlockPatch')
insert into control_objects (obj_id, app_id, obj_name) values (41, 1, 'ApprovedByManager')
insert into control_objects (obj_id, app_id, obj_name) values (42, 1, 'ApprovedByTester')
insert into control_objects (obj_id, app_id, obj_name) values (44, 1, 'ChangeVersion')
insert into control_objects (obj_id, app_id, obj_name) values (45, 1, 'GMPTE')
insert into control_objects (obj_id, app_id, obj_name) values (46, 1, 'SanFrancisco')
insert into control_objects (obj_id, app_id, obj_name) values (47, 1, 'ConfigureBuildService')
insert into control_objects (obj_id, app_id, obj_name) values (48, 1, 'ConfigureRelease')
insert into control_objects (obj_id, app_id, obj_name) values (49, 1, 'SetToReproducible')
insert into control_objects (obj_id, app_id, obj_name) values (50, 1, 'ApproveForPendingDeployment')
insert into control_objects (obj_id, app_id, obj_name) values (51, 1, 'ApproveForPendingIntegration')
insert into control_objects (obj_id, app_id, obj_name) values (52, 1, 'ApproveForPendingTest')
insert into control_objects (obj_id, app_id, obj_name) values (53, 1, 'RejectProduct')
insert into control_objects (obj_id, app_id, obj_name) values (54, 1, 'ApprovePendingIntegrateAndDeploy')
insert into control_objects (obj_id, app_id, obj_name) values (55, 1, 'DestroyPackageFromRelease')
insert into control_objects (obj_id, app_id, obj_name) values (56, 1, 'EditNonCriticalInfoForLockedPackage')
insert into control_objects (obj_id, app_id, obj_name) values (57, 1, 'EditCriticalInfoForLockedPackage')

insert into roles (role_id, app_id, role_name) values (1, 1, 'Deployment Manager developer')
insert into roles (role_id, app_id, role_name) values (2, 2, 'Release Manager developer')
insert into roles (role_id, app_id, role_name) values (3, 9, 'Access Manager developer')
insert into roles (role_id, app_id, role_name) values (4, 10, 'Production Manager developer')

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (1, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (2, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (3, 57, 2, 'Y');

insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 1, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 2, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 3, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 4, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 5, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 6, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 7, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 8, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 10, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 11, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 12, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 13, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 14, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 15, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 16, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 17, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 18, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 19, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 20, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 21, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 22, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 23, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 24, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 25, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 26, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 27, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 28, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 29, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 30, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 31, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 32, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 33, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 34, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 35, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 36, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 37, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 38, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 39, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 40, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 41, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 42, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 44, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 45, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 46, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 47, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 48, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 49, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 50, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 51, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 52, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 53, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 54, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 55, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 56, 2, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 1, 'Y');
insert into role_privileges (role_id, obj_id, perm_id, perm_value) values (4, 57, 2, 'Y');

insert into user_roles (user_id, role_id) values (1, 1);
insert into user_roles (user_id, role_id) values (1, 2);
insert into user_roles (user_id, role_id) values (1, 3);
insert into user_roles (user_id, role_id) values (1, 4);
insert into user_roles (user_id, role_id) values (2, 1);
insert into user_roles (user_id, role_id) values (2, 2);
insert into user_roles (user_id, role_id) values (2, 3);
insert into user_roles (user_id, role_id) values (2, 4);