Maximo Open Forum

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

    Posted 15 days ago

    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 14 days ago

    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 12 days ago

    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
    ------------------------------