script will list unnecessary privs in the APPLSYSPUB account

col GRANTOR    format a24
col PRIVILEGE  format a14
col TABLE_NAME format a32

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#’);

  • January 19, 2019 | 20 views
  • Comments