NetIQ Vulnerability Manager report 'Users with Programming Functions' provides incorrect results. (NETIQKB53647)

  • 7753647
  • 02-Feb-2007
  • 18-May-2007

Resolution

fact
VigilEnt Security Agent for iSeries 7.5

fact
NetIQ Security Solutions for iSeries 8.0

fact
NetIQ Vulnerability Manager 5.0

fact
NetIQ Vulnerability Manager 5.5

symptom
NetIQ Vulnerability Manager report 'Users with Programming Functions' provides incorrect results.

symptom
The NetIQ Vulnerability Manager report  'Users with Programming Functions'  includes user profiles that do not have User Class *PGMR.

fix

To correct this report, complete the following steps:

  1. On an iSeries command line, run the following command: STRSQL
  2. Run the following statement on the 'Enter SQL Statements' screen:
  3. UPDATE PSCOMMON/PSEMETA SET MCMETA = '*PGMR', MCPARMLST = 1,
    MCASHTML = 'N', MCSELECT = 
    'CREATE VIEW QTEMP/PSAUDITX AS SELECT DISTINCT * FROM QTEMP/PSAUDIT
    WHERE UPUSCL = ''*PGMR''' WHERE MCMETA = '*PGMR' and MCCMD = ' '  
    and MCPARMLST = 1 and MCASHTML = 'N' and MCTEMPLAT = ' ' and      
    MCSELECT =                                                        
    'CREATE VIEW QTEMP/PSAUDITX AS SELECT DISTINCT * FROM QTEMP/PSAUDIT
    WHERE UPSPAU = ''*NONE'''

  4. If you need to update the file PSCOMMON/PSEMETA on another iSeries server, on the 'Enter SQL Statements' screen, first use CONNECT TO server USER user USING password, run the SQL update statement shown above, then use DISCONNECT server, where server, user, and password are your own values.


Additional Information

Formerly known as NETIQKB53647

Feedback service temporarily unavailable. For content questions or problems, please contact Support.