Grants required for WCC user in Oracle

Document ID : KB000102447
Last Modified Date : 19/06/2018
Show Technical Document Details
Question:
What grants are required for WCC user in Oracle?
Answer:
GRANT CREATE ANY SEQUENCE to WCC; 
GRANT CREATE TABLE to WCC; 
GRANT CREATE ANY INDEX to WCC; 
GRANT CREATE SESSION to WCC; 
GRANT ALTER ANY TABLE to WCC; 
GRANT DROP ANY INDEX to WCC; 
GRANT UNLIMITED TABLESPACE to WCC;