Required Oracle Privileges

Privilege

Usage

Comments

ALTER ANY SEQUENCE

Set the START AT parameter after loading Access data.

See "ANY" note.

ALTER ANY TABLE

Constraint and  triggers are disabled and enabled. Primary, unique, and foreign keys are added.

See "ANY" note.

ALTER ANY TRIGGER

Required for disabling / enabling triggers

See "ANY" note.

ALTER DATABASE

Used to alter table space DATAFILE size.

Only required when table spaces are modified by Scriptoria.

ALTER SESSION

Used to set current schema.

Always required.

ALTER TABLESPACE

Used when recreating table spaces.

Only required when table spaces are modified by Scriptoria.

CREATE ANY INDEX

Always required.

See "ANY" note.

CREATE ANY PROCEDURE

Query translator creates procedures when converting action queries.

Only required with Query Translator

CREATE ANY SEQUENCE

Auto-Numbers are implemented using Oracle sequences.

Often required

CREATE ANY TABLE

Always required.

See "ANY" note.

CREATE ANY TRIGGER

Triggers are used to implement auto-number functionality, some validation rules, case rules, and cascade update relationships.

See "ANY" note.

CREATE ANY VIEW

Access Select queries are implement using views.

Required by Query Translator only.

CREATE PUBLIC SYNONYM

Used only when installing VBA package.

Only required with Query Translator module.

CREATE TABLESPACE

Used when Scriptoria creates table spaces.

Optional privilege.

CREATE USER

Issued when new user entered in Schema Options form and when installing VBA package.

Optional privilege.

DELETE ANY TABLE

Existing data may be deleted before data is exported.

Often required.

DROP ANY PROCEDURE

Procedures are replaced if they exist when recompiling.

Required by Query Translator module.

DROP ANY SEQUENCE

Sequences are dropped when recreating tables that utilize them.

Often required.

DROP ANY TABLE

Tables are dropped when they exist before they are recreated.

Often required.

DROP ANY TRIGGER

Triggers are replaced if they exist before they are recreated.

Often required.

DROP ANY VIEW

Views are replaced if they exist before they are recreated.

Required by Query Translator only.

DROP PUBLIC SYNONYM

Used only when reinstalling VBA functions package.

Required by Query Translator only.

DROP TABLESPACE

Scriptoria optionally drops table spaces with users approval.

Only required when Scriptoria is used to manage table spaces.

DROP USER

Used only when reinstalling VBA functions package.

Required by Query Translator only.

EXECUTE ANY LIBRARY

Not currently used by Scriptoria.

EXECUTE ANY PROCEDURE

Not used directly by Scriptoria but required when testing query conversions.

Required by Query Translator only.

GRANT ANY PRIVILEGE

Grants are issued when new users are created.

Optional privilege.

INSERT ANY TABLE

Data is inserted into tables when exported.

Often required.

SELECT ANY SEQUENCE

Sequences are used to implement auto-number functionality.

Often required.

SELECT ANY TABLE

Used for Scriptoria system functions and user testing.

Often required.

UPDATE ANY TABLE

Used when INSERT_UPDATE loader option is selected and for user testing.

Often required.