Hi @Trisha S!
This query will give you a list of security groups that have active users who are not in MAXADMIN group. Then, from those groups, it will look for applications with INSERT, SAVE, and DELETE sigoptions.
What you should do is look in those Maximo security groups, in those applications and eliminate the check marks that are not READ.
select groupname, app, optionname from maximo.applicationauth where optionname in ('SAVE', 'INSERT', 'DELETE')
and groupname in (select groupname from maximo.groupuser where groupname not in ('MAXADMIN') and userid in (select userid from maximo.maxuser where status = 'ACTIVE')) order by groupname, app, optionname
Regards!
------------------------------
Martin Fabra
ARSAT S.A. - Actively seeking employment
------------------------------
Original Message:
Sent: 02-14-2024 13:22
From: Trisha S
Subject: Make all users have readonly access except for maxadmin
Hi,
Can anyone help me with this?
I have to make all active users have only readonly access( so that they do not make any changes) except for Maxadmins?
If i do manually it will take huge time, what are the other ways but which i make sure they have only read only access
Thanks
#Administration
#Analytics
#Architecture
#Assets
#CivilInfrastructure
#Customizations
#EndUser
#EverythingMaximo
#HSE/OilandGas
#Infrastructure
#Integrations
#Inventory
#IoT
#LifeScience/Calibration
#Linear
#MaximoApplicationSuite
#MaximoForAviation
#MaximoUserGroups
#Mobility
#Nuclear
#Procurement
#Reporting
#Scheduling
#Security
#ServiceProvider
#Spatial
#Transportation
#Utilities
#WorkCenters
#WorkManagement
#MaximoVisualInspection
#Predict
#Monitor
#Health
#Assist
#Safety
------------------------------
Trisha S
Tcs
------------------------------