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

See Also

Oracle Database Support