O'Reilly logo

Oracle E-Business Suite Security by John Abel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required