VMWare Chargeback + Oracle DB permissions required

[Michal_Lukowicz]

Hello All

I am not DB person so forgive me if i am asking stupid question.

While installing Chargeback documentation says that db user should have create schema / delete schema permission.

I spent a lot of time googlig but i am not able to find such permission in Oracle.

Can you pls advise me what should they be? I would like to give user minimum required rights.

Michał

[Michal_Lukowicz]

Hi

Got it via testing:

PRIVILEGE
---------------------------------------
CREATE SESSION
CREATE ANY TABLE
DROP ANY TABLE
CREATE ANY CLUSTER
DROP ANY CLUSTER
CREATE ANY INDEX
DROP ANY INDEX
CREATE ANY SYNONYM
DROP ANY SYNONYM
CREATE ANY VIEW
DROP ANY VIEW

PRIVILEGE
---------------------------------------
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE ANY TRIGGER
DROP ANY TRIGGER
CREATE MATERIALIZED VIEW
CREATE ANY DIMENSION
DROP ANY DIMENSION

+ you need to increase quota on table users:

alter user <username> quota 200M on users; (i am not sure how much quota it needs 200 was just a shot).

Michał