Question on DB user and rights

Document ID : KB000097699
Last Modified Date : 11/06/2018
Show Technical Document Details
Issue:
We received an error during WCC Installation today. We are using and Oracle DB for WCC and created user autcawcc for it. We are receiving the following error: 

2018-05-15 17:09:16 : DatabaseUtil:: Running SQL statement as update: CREATE TABLE INSTEST_1526418555 (TEST integer) 
2018-05-15 17:09:16 : DatabaseUtil:: Running SQL statement as update: INSERT INTO INSTEST_1526418555 VALUES(1) 
2018-05-15 17:09:16 : DatabaseUtil:: The specified user does not have the required database rights. Verify that the user has the right to insert data into the table. 

Here are the privileges currently assigned to the user: 
SQL> select GRANTEE,PRIVILEGE from dba_sys_privs where grantee='AUTCAWCC'; 
GRANTEE PRIVILEGE 
-------- ---------------------------------------- 
AUTCAWCC ALTER ANY TABLE 
AUTCAWCC CREATE TABLE 
AUTCAWCC DROP ANY INDEX 
AUTCAWCC DELETE ANY TABLE 
AUTCAWCC UPDATE ANY TABLE 
AUTCAWCC INSERT ANY TABLE 
AUTCAWCC CREATE ANY INDEX 
AUTCAWCC CREATE SESSION 
AUTCAWCC CREATE SEQUENCE 
Environment:
WAAE 11.3.6 SP7
Cause:
A privilege was missing.
Resolution:
Add the following to the DB: GRANT UNLIMITED TABLESPACE to AUTCAWCC ;