Minimum Permissions Needed for Oracle Users
In order to connect to an Oracle database from Iron Speed Designer the Oracle user must have the following privilege:
CREATE SESSION
In order to create and execute stored procedures the Oracle user must have the following privileges:
CREATE PROCEDURE
EXECUTE PROCEDURE
In order to see tables, views, and sequences in Iron Speed Designer the Oracle user must have the following privileges on the desired tables, views, and sequences:
SELECT
In order to read and write data using an application created with Iron Speed Designer the Oracle user must have the following privileges on the desired objects (i.e. tables, views, sequences):
DELETE
INSERT
SELECT
UPDATE