Creating tablespaces and user on the Oracle database for TrueSight Smart Reporting

On the Oracle database, you can use the same tablespace as TrueSight Server Automation - Data Warehouse. However, if required, you can create a new tablespace for TrueSight Smart Reporting.

On the Oracle database, you must create a user with appropriate rights for TrueSight Smart Reporting. Ask your database administrator to do the following:

1. If required, create a tablespace in the Oracle database. Use the following command:

   CREATE  TABLESPACE TSR_REPOSITORY LOGGING DATAFILE  REPOSITORY_01.dbf SIZE 1G REUSE AUTOEXTEND ON NEXT 500M MAXSIZE 30G EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO

2. Create a user in the Oracle database. Use the following command:

   Command

   CREATE USER <user> PROFILE DEFAULT IDENTIFIED BY <password>;

   Example

   CREATE USER SMARTREPORTINGUSER PROFILE DEFAULT IDENTIFIED BY SMARTREPORTINGPASSWORD;

3. Run the following commands in the given order to grant privileges to the user:

   1. GRANT CREATE MATERIALIZED VIEW TO SMARTREPORTINGUSER;
   2. GRANT CREATE VIEW TO SMARTREPORTINGUSER;
   3. GRANT QUERY REWRITE TO SMARTREPORTINGUSER;
   4. GRANT UNLIMITED TABLESPACE TO SMARTREPORTINGUSER;
   5. GRANT RESOURCE TO SMARTREPORTINGUSER;
   6. GRANT CREATE TABLE TO SMARTREPORTINGUSER;
   7. GRANT EXECUTE ON DBMS_LOCK TO SMARTREPORTINGUSER;
   8. GRANT CONNECT TO SMARTREPORTINGUSER;