Integrity Checker reports this error, followed by a list of user ids:
BMXAA0443E - ERROR -- BMXAA0455E - The following users should be removed from Maximo because they have no MAXIMO privileges:
Obsolete/orphan user ids are defined in Maximo, but user id has no access to or privileges in Maximo.
Users are defined in table MaxUser, but are not associated with any Maximo group in table GroupUser. Any user not associated with a group has no privileges in Maximo.
Diagnosing the problem
To verify these user ids are orphans - that is, not defined in table GroupUser, execute this query:
Select userid From maxuser Where Not Exists (Select * From groupuser Where userid=maxuser.userid)
This query should return the same list of users that follows the BMXAA0455E error message.
Resolving the problem
Review the list of users to verify that they are obsolete and can be removed. To drop the users from table MaxUser:
Delete From maxuser Where Not Exists (Select * From groupuser Where userid=maxuser.userid)
Run Integrity Checker (report-mode only) again to verify the error is resolved.
|Systems and Asset Management||Tivoli Asset Management for IT||Not Applicable|
|Systems and Asset Management||Tivoli Change and Configuration Management Database|
|Systems and Asset Management||Tivoli Service Request Manager|