Validate User Privileges Script For Oracle

Go Up To Database Server Requirements

Script For Oracle Permissions

This script applies the permissions required for Team Server to run on Oracle for the User 'erstudio' Please replace 'erstudio' with the username you wish to use during the installation of Team Server

CREATE USER erstudio IDENTIFIED BY erstudio;

GRANT CONNECT, resource TO erstudio;

GRANT SELECT_CATALOG_ROLE TO erstudio;

GRANT CREATE INDEXTYPE TO erstudio;

GRANT CREATE PROCEDURE TO erstudio;

GRANT CREATE SEQUENCE TO erstudio;

GRANT CREATE SESSION TO erstudio;

GRANT CREATE SYNONYM TO erstudio;

GRANT CREATE TABLE TO erstudio;

GRANT CREATE TRIGGER TO erstudio;

GRANT CREATE TYPE TO erstudio;

GRANT CREATE VIEW TO erstudio;

GRANT UNLIMITED TABLESPACE TO erstudio;

GRANT EXECUTE ON DBMS_SQL TO erstudio;

GRANT EXECUTE ON DBMS_LOB TO erstudio;

GRANT EXECUTE ON DBMS_RANDOM TO erstudio;