Below is a quick list of compiled permissions that will work for AcuitiDP if your DBA is paranoid about giving DBA permissions.
The optional column is "REQUIRED" when you're initializing your database/DNN site (for example when you run DNN for the first time). It is also "REQUIRED" if you have to install modules or alter/update modules, etc.
| Permission |
Required |
Optional |
Desired |
| CREATE SESSION |
X |
|
|
| ALTER SESSION |
X |
|
|
| UNLIMITED TABLESPACE |
|
|
X |
| CREATE USER |
|
X |
|
| CREATE TABLE |
|
X |
|
| CREATE ANY TABLE |
|
X |
|
| ALTER ANY TABLE |
|
X |
|
| DROP ANY TABLE |
|
X |
|
| SELECT ANY TABLE |
X |
|
|
| INSERT ANY TABLE |
X |
|
|
| UPDATE ANY TABLE |
X |
|
|
| DELETE ANY TABLE |
X |
|
|
| CREATE ANY INDEX |
|
X |
|
| ALTER ANY INDEX |
|
X |
|
| DROP ANY INDEX |
|
X |
|
| CREATE SYNONYM |
|
X |
|
| CREATE ANY SYNONYM |
|
X |
|
| DROP ANY SYNONYM |
|
X |
|
| CREATE VIEW |
|
X |
|
| CREATE ANY VIEW |
|
X |
|
| DROP ANY VIEW |
|
X |
|
| CREATE SEQUENCE |
|
X |
|
| CREATE ANY SEQUENCE |
|
X |
|
| ALTER ANY SEQUENCE |
|
X |
|
| DROP ANY SEQUENCE |
|
X |
|
| SELECT ANY SEQUENCE |
X |
|
|
| CREATE PROCEDURE |
|
X |
|
| CREATE ANY PROCEDURE |
|
X |
|
| ALTER ANY PROCEDURE |
|
X |
|
| DROP ANY PROCEDURE |
|
X |
|
| EXECUTE ANY PROCEDURE |
X |
|
|
| CREATE TRIGGER |
|
X |
|
| CREATE ANY TRIGGER |
|
X |
|
| ALTER ANY TRIGGER |
|
X |
|
| DROP ANY TRIGGER |
|
X |
|
| CREATE TYPE |
|
X |
|
| CREATE ANY TYPE |
|
X |
|
| ALTER ANY TYPE |
|
X |
|
| DROP ANY TYPE |
|
X |
|
| CREATE INDEXTYPE |
|
X |
|
| CREATE ANY INDEXTYPE |
|
X |
|
| ALTER ANY INDEXTYPE |
|
X |
|
| DROP ANY INDEXTYPE |
|
X |
|
| SELECT ANY DICTIONARY |
X |
|
|
| CREATE RULE SET |
|
X |
|
| ALTER ANY RULE SET |
|
X |
|
| DROP ANY RULE SET |
|
X |
|
| CREATE RULE |
|
X |
|
| CREATE ANY RULE |
|
X |
|
| ALTER ANY RULE |
|
X |
|
| DROP ANY RULE |
|
X |
|