(SEC-28) Invalid entries in the PSAUTHITEM table:
this is part of: SYSAUDIT (SEC-28) Invalid Entries In The PSAUTHITEM Table (Doc ID 2590980.1)
I wondered if I run this query will it fix the issue. I can see that the number of issues I have are matching with the numbers of incoming rows from the query below, if you add a SELECT on the front of it.
-----------------------------
This is from the report:
(SEC-28) Invalid entries in the PSAUTHITEM table:
CLASSID: name
MENUNAME: name
SETUP BARITEMNAME: name
PNLITEMNAME: name
Run the following SQL:
DELETE FROM PSAUTHITEM WHERE (PSAUTHITEM.MENUNAME NOT LIKE 'WEBLIB_%' AND PSAUTHITEM.MENUNAME NOT IN ('CLIENTPROCESS', 'DATA_MOVER', 'IMPORT_MANAGER', 'OBJECT_SECURITY', 'QUERY', 'PERFMONPPMI' ) AND PSAUTHITEM.MENUNAME NOT LIKE ('APPLICATION_DESIGNER%') AND NOT (PSAUTHITEM.MENUNAME = 'ADS_DESIGNER' AND PSAUTHITEM.BARNAME = 'TOOLS_DATASETS') AND PSAUTHITEM.MENUNAME <>'REN' AND NOT EXISTS (SELECT 'X' FROM PSMENUITEM MI WHERE PSAUTHITEM.MENUNAME = MI.MENUNAME AND PSAUTHITEM.BARNAME = MI.BARNAME AND PSAUTHITEM.BARITEMNAME = MI.ITEMNAME AND ( MI.ITEMTYPE IN (0, 1, 2, 3, 4, 6, 7, 8, 10, 11) OR (MI.ITEMTYPE = 5 AND EXISTS (SELECT 'X' FROM PSPNLGRPDEFN GD, PSPNLGROUP GI WHERE MI.PNLGRPNAME = GD.PNLGRPNAME AND MI.MARKET = GD.MARKET AND GD.PNLGRPNAME = GI.PNLGRPNAME AND GD.MARKET = GI.MARKET AND