There are several situation where you need to quickly notify a set of users sending them an email. These are few examples of such situations. There is a urgent maintenance activity to perform on Maximo that requires to enable the admin mode and logoff all the users. You are going to rollout an additional validation […]
We all know how flexible Security Groups are when dealing with user roles and granting application authorizations. However, flexibility often brings complexity.You have carefully designed user’s roles defining what applications and actions they are allowed to access in Maximo and implemented all using Security Groups application. The system goes live and after one or two […]
Maximo installation configures by default HTTP unencrypted communication. This basic configuration may represent a security exposure especially when the server is reachable from the public internet. This article describes all the steps needed to enable HTTPS (SSL) communications for Maximo. It comprises the following main steps. Creation of a self-signed certificate IBM HTTP Server configuration […]
The following SQL query lists all the security groups and the associated users. SELECT maxgroup.groupname, maxgroup.description, maxuser.userid, maxuser.loginid, maxuser.defsiteFROM maxgroupJOIN groupuser ON groupuser.groupname=maxgroup.groupnameJOIN maxuser ON maxuser.userid=groupuser.useridORDER BY maxgroup.groupname, maxuser.userid; The best approach to analyze the results is to load them into Excel and create a pivot table.
This entry is part of the Conditional Expressions HowTo. In Maximo/TPAE menu items are granted per security group in the Security Groups application. Every option available for an application has a corresponding signature option (aka sigoption) record in the SIGOPTION table. Those SigOptions can be configured in the Application Designer. In this article I will […]
Did you have ever spent precious time searching in the Group Security application what group grants a specific permission to a certain user?Do you want to list all the sigoption granted to a specific user?Do you want to list all the groups to which a specific user belongs together with all the granted sigoptions?Do you […]
The standard Maximo ‘Security Groups’ application provides an easy way to view and modify users access to applications. However it is not always easy to have an overview of what groups are granted to access a specific application or what applications can be accessed by a specific group.With the following SQL query you can get […]