Maximo Open Forum

 View Only
  • 1.  Pull SIGOPTION.AUTHORIZED from Security Groups application

    Posted 02-09-2024 17:04

    Hello all,

    I'm looking for a way to quickly analyze what boxes are checked to review a group's security permissions. 

    I can't seem to add this option for reports.  Would SQL be the best option?  Is that possible?

    Thank you in advance.


    #Administration
    #EverythingMaximo
    #Reporting
    #Security

    ------------------------------
    Danny Richardson
    Technimark LLC
    ------------------------------


  • 2.  RE: Pull SIGOPTION.AUTHORIZED from Security Groups application

    Posted 02-10-2024 12:36

    Hi It will be better to use the MxLoader get the access details.



    ------------------------------
    Vivek Nagre
    JLL
    ------------------------------



  • 3.  RE: Pull SIGOPTION.AUTHORIZED from Security Groups application

    Posted 02-12-2024 05:41

    Hi Danny,

    The APPLICATIONAUTH table holds all the options per security group that has been granted.  That is simplest, though may be ugly.

    In the security group application there is the Security Group Access report.  Again, ugly, but goes some of the way.

    BTW: You said "I can't seem to add this option for reports" errr what option are referring to?



    ------------------------------
    Craig Kokay
    Principal Consultant
    COSOL

    email: craig.kokay@cosol.global
    #IBMChampion
    ------------------------------