Database Administration (MOSC)

MOSC Banner

(SEC-28) Invalid entries in the PSAUTHITEM table:

edited Feb 25, 2022 11:40PM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center