No Users Showing For System Permissions Follow
Bug has been reintroduced into System Permissions that if there is a deleted user in system permissions, no users show
This Script will find the deleted users: (Must be run from Assignments table in System Permissions DB)
SELECT *
FROM Assignments
WHERE (AssignedFor NOT IN
(SELECT UserID
FROM Production_Portal_PortalFx.dbo.PWUser))
Then
DELETE
FROM Assignments
WHERE (AssignedFor NOT IN
(SELECT UserID
FROM Production_Portal_PortalFx.dbo.PWUser))
Then run this one on the Requests table in System Permissions
SELECT *
FROM Requests
WHERE (UserID NOT IN
(SELECT UserID
FROM Production_Portal_PortalFx.dbo.PWUser))
Then
DELETE
FROM Requests
WHERE (UserID NOT IN
(SELECT UserID
FROM Production_Portal_PortalFx.dbo.PWUser))
Comments
0 comments
Please sign in to leave a comment.