The database user must have the following privileges in an Oracle environment:
-
Membership of the SELECT_CATALOG_ROLE database role with the admin option.
-
The CREATE SESSION privilege with the admin option.
-
The CREATE TABLE privilege with the admin option.
-
The CREATE VIEW privilege with the admin option.
-
The UNLIMITED TABLESPACE privilege with the admin option.
-
The CREATE ROLE privilege.
-
The GRANT ANY ROLE privilege.
-
The CREATE TABLESPACE privilege.
-
Membership of CONNECT database role with the admin option.
-
The CREATE USER privilege with the admin option.
-
The ALTER USER privilege with the admin option.
-
The DROP USER privilege with the admin option.
-
The GRANT ANY OBJECT privilege.
-
The SELECT ANY TABLE privilege.