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