script will list unnecessary privs in the APPLSYSPUB account

select GRANTOR,PRIVILEGE, TABLE_NAME
  from  DBA_TAB_PRIVS
 where  grantee = ‘APPLSYSPUB’
   and  privilege in (‘SELECT’,’INSERT’,’EXECUTE’,’DELETE’)
   and  Rtrim(privilege) || ‘ ON ‘ || table_name NOT IN
(‘INSERT ON FND_SESSIONS’,
‘INSERT ON FND_UNSUCCESSFUL_LOGINS’,
‘EXECUTE ON FND_DISCONNECTED’,
‘EXECUTE ON FND_MESSAGE’,
‘EXECUTE ON FND_PUB_MESSAGE’,
‘EXECUTE ON FND_SECURITY_PKG’,
‘EXECUTE ON FND_SIGNON’,
‘EXECUTE ON FND_WEBFILEPUB’,
‘SELECT ON FND_APPLICATION’,
‘SELECT ON FND_APPLICATION_TL’,
‘SELECT ON FND_APPLICATION_VL’,
‘SELECT ON FND_LANGUAGES_TL’,
‘SELECT ON FND_LANGUAGES_VL’,
‘SELECT ON FND_LOOKUPS’,
‘SELECT ON FND_PRODUCT_GROUPS’,
‘SELECT ON FND_PRODUCT_INSTALLATIONS’,
‘SELECT ON FND_NEW_MESSAGES’,
‘INSERT ON FND_SESSIONS#’,
‘INSERT ON FND_UNSUCCESSFUL_LOGINS#’,
‘SELECT ON FND_APPLICATION#’,
‘SELECT ON FND_APPLICATION_TL#’,
‘SELECT ON FND_PRODUCT_GROUPS#’,
‘SELECT ON FND_PRODUCT_INSTALLATIONS#’,
‘SELECT ON FND_LANGUAGES_TL#’,
‘SELECT ON FND_NEW_MESSAGES#’);