Querying predefined security groups

You can run SQL queries to list all of the security groups and their associated roles that are unique to Maximo® Aviation. You can also run a query to list the applications and permission types for each security group.

1. In the database, run the following SQL query to list all predefined security groups:

   select groupname, description from maxgroup where groupname in 
   ('ACCOUNTANT', 'ACMTCEMGR', 'BMTCEMGR', 'CERTSTF', 'CTCMKTMGR', 'CUSORDSK', 
   'CUSTOMER', 'ENGMGR', 'ENGSPEC', 'FINCTL', 'FINMGR', 'HUMRES', 'LMTCEMGR', 
   'MATMGR', 'MATPLAN', 'MCCCTRL', 'MTCEPLN', 'MTCEPRENG', 'PRODCTL', 'PURCHASER', 
   'RECSPEC', 'RELYANLT', 'SMSALST', 'SMSMGR', 'STOKEEPER', 'TECHNICIANS', 
   'TECLIBMGR', 'TECLIBSPEC', 'TECPLNMGR', 'TECSRVMGR', 'WAREMGR', 'WARRMGR',
    'WKSPMGR', 'ML_CONTRACT', 'ML_ENGINEER', 'ML_FINANCE', 'ML_HUMRES', 
   'ML_LOGISTICS', 'ML_MAINTENANCE', 'ML_PLANNING', 'ML_QUALITY', 'ML_SAFETYMGNT',
   'ML_SALES', 'ML_TECHANY', 'ML_TECHNICAL', 'QUALMGR', 'QUALAUD', 'QUALCTRL')

2. To list all the applications that are available for the selected security group, replace the placeholder <GROUPNAME> with the name of your security group in the following SQL query:

   select auth.groupname,app.description,auth.optionname 
   from applicationauth auth, maxapps app 
   where auth.groupname=’<GROUPNAME>’ and auth.app=app.app and auth.optionname 
   in (’INSERT’,’SAVE’,’READ’,’DELETE’) 
   order by app.app