For details, see:

Using Oracle with Iron Speed Designer

Database Field Support in Oracle

Minimum Permissions Needed for Oracle Users

Changing an Oracle Database Schema Name in an Application

PL/SQL Stored Procedures

Matching Oracle Sequences with Primary Keys

Multiple database support