upd data ủy quyền.txt
| 1 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (NULL, 0) |
|---|---|
| 2 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Approve', 1) |
| 3 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Create', 2) |
| 4 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Delete', 3) |
| 5 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Edit', 4) |
| 6 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Reject', 5) |
| 7 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Search', 6) |
| 8 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'Update', 7) |
| 9 |
INSERT SYS_ALL_PERMISSION_MENU(PER_NAME, PER_ROW) VALUES (N'View', 8) |
| 10 |
DELETE FROM SYS_ALL_PERMISSION |
| 11 |
INSERT INTO SYS_ALL_PERMISSION(MENU_PERMISSION, MENU_PERMISSION_NAME) |
| 12 |
SELECT A.MENU_PERMISSION, A.MENU_PERMISSION + ISNULL('.' + B.PER_NAME, '') AS MENU_PERMISSION_NAME
|
| 13 |
FROM TL_MENU A |
| 14 |
LEFT JOIN SYS_ALL_PERMISSION_MENU B ON 1 = 1 AND (ISNULL(A.MENU_LINK, '') = ISNULL(B.PER_NAME, '') OR ISNULL(A.MENU_LINK, '') <> '') |