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
------------------------------
Original Message:
Sent: 03-05-2024 12:30
From: Kaman Doyle
Subject: All applications are available despite security.
I am currently able to access every application in the instance, despite my security groups only allowing a select few. I have troubleshooted to the best of my ability however I am unable to resolve. Any advice appreciated.
#Security
------------------------------
Kaman Doyle
BIG
------------------------------