The following are useful SQL statements that can be used to monitor Oracle E-Business Suite and validate the security elements.
To verify that the database passwords have been changed from their default, run the following script:
Set head off Set pagesize 0 Spool <default_dir>/valid_users.sql select 'Prompt '||username||chr(10)|| 'connect '|| username||'/'||username||';' from dba_users; spool off spool @password_check.txt @<default_dir>/valid_users.sql spool off
The following SQL will validate the protocol that is being used (for example HTTP or HTTPS). We have set the condition %http:% that will perform a wildcard search, looking through system profile options. This is very useful if you have changed protocols ...