Oracle E-Business Suite Security

Useful Oracle Database SQL Scripts

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 ...