Sometimes in the Cireson Portal you may find an analyst complains that they are unable to access a certain work item.
The following SQL query allows you to check their permissions. It will output the WI details and also the user permissions.
Run this against the ServiceManagment db…
exec spCheck_UserWorkItemPermissions ‘username‘,’workitemID‘