This query will show you the security groups that the user belongs to.
select * from maximo.groupuser where userid = 'USERID'
This other query will give you all the permissions that those security groups have.
select * from maximo.applicationauth where groupname in (select groupname from maximo.groupuser where userid = 'USERID') order by groupname, app, optionname
They should be consistent, that is, the groups to which the user belongs would give the permissions within the system. Verify that this is what is being accessed by the system.
Regards!
------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------