Oracle

CREATE TABLE

CREATE TABLE

CREATE ANY INDEX

DML Privileges

CREATE ANY SEQUENCE

CREATE TABLESPACE (for Reports)

ALTER TABLESPACE

CREATE PROCEDURE

UNLIMITED TABLESPACE (for Reports, optional)

DROP TABLESPACE

ALTER ANY TABLE

DML Privileges (including CREATE SESSION privilege)

MS SQL Server

Note: UserID must also have the database role of ddladmin. If the database user is dbowner, then the database user already has ddladmin privileges.

CREATE TABLE

CREATE TABLE

CREATE INDEX

DML Privileges

CREATE PROCEDURE

EXECUTE PROCEDURE

REFERENCES

ALTER TABLE

DML Privileges