Add Menu + Role
unknown
sql
a year ago
1.0 kB
1
Indexable
Never
INSERT INTO M_MENUS (ID, IS_LEAF, NAME, PAGE_URL, PARENT_ID, LEVEL, URUTAN, GROUP, URUTAN_HEADER, APP_NAME) VALUES(3, 0, 'Umum', '/umum/HomePage.html', NULL, 1, 1, 'Umum', 1, 'STAR') --Bikin Top Menu INSERT INTO M_MENUS (ID, IS_LEAF, NAME, PAGE_URL, PARENT_ID, LEVEL, URUTAN, GROUP, URUTAN_HEADER, APP_NAME) VALUES(301, 1, 'Ajukan Temuan Hilang', '/umum/FormBarangHilang.html', 3, 99, 1, 'Umum', 1, 'STAR') --Bikin Left Menu INSERT INTO M_ROLES (ROLE_ID, DESCRIPTION, NAME, CREATED_BY, CREATED_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, IS_ROLE, IS_KPUSAT, IS_IDM_ACCESS, IDM_USERSTATUS_ID) VALUES(333, 'Role Testing by Ari Utomo', 'ROLE_TEST_ARI', '3005', '2023-09-09-20.31.45.000000', '3005', '2023-09-09-20.31.45.000000', 1, 1, 1, 1) --ADD NEW Role INSERT INTO USER_ROLE (USER_ID, ROLE_ID) VALUES(3005 ,333) --Assign ROLE TO User INSERT INTO ROLE_MENU (ROLE_ID, MENU_ID) VALUES(333,3) --ADD Menu TO ROLE INSERT INTO ROLE_MENU (ROLE_ID, MENU_ID) VALUES(333,301) --ADD Menu TO ROLE