DELETE_ROLE.txt
| 1 |
DELETE AbpUserRoles WHERE Id IN ( |
|---|---|
| 2 |
|
| 3 |
SELECT AUR.Id FROM AbpUserRoles AUR WHERE AUR.UserId IN ( |
| 4 |
|
| 5 |
SELECT B.UserId |
| 6 |
FROM TL_USER A |
| 7 |
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId |
| 8 |
WHERE B.CreatorUserId <> 0 |
| 9 |
GROUP BY B.UserId,B.RoleId |
| 10 |
HAVING COUNT(*) > 1 ) |
| 11 |
AND AUR.CreatorUserId <> 0 |
| 12 |
) |
| 13 |
|
| 14 |
DELETE AbpUserRoles WHERE Id IN ( |
| 15 |
|
| 16 |
SELECT AUR.Id FROM AbpUserRoles AUR WHERE AUR.UserId IN ( |
| 17 |
|
| 18 |
SELECT B.UserId |
| 19 |
FROM TL_USER A |
| 20 |
LEFT JOIN AbpUserRoles B ON A.ID = B.UserId |
| 21 |
GROUP BY B.UserId,B.RoleId |
| 22 |
HAVING COUNT(*) > 1 ) |
| 23 |
AND AUR.CreatorUserId <> 0 |
| 24 |
--ORDER BY AUR.UserId |
| 25 |
|
| 26 |
) |