Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Configuring the Oracle Business Analytics Warehouse Database >

Process of Creating the SSE Role


Follow this procedure to create the SSE role.

To create the SSE Role

  • Create a database role named SSE_ROLE (SSEROLE for DB2 390 databases). Assign this role to the database user. For instructions on creating roles, see the documentation provided with your database.

    For example, on an Oracle database you might use the 'CREATE ROLE' SQL command to create the role, and the GRANT command to assign privileges to the role, and to assign the role to the data warehouse database account.

Note the following:

  • For an Oracle database, when you create the SSE_ROLE role, you need to grant the following privileges:
    • CONNECT
    • RESOURCE
  • For an Oracle database, if the DAC repository and the Informatica repository are stored in a different database to the data warehouse database, the SSE_ROLE must have the following additional privileges:
    • READ
    • WRITE
    • UPDATE
    • DELETE
    • GRANT
  • If you are using a Teradata database, you do not need to create the SSE role. If you are using a DB2 390 database, you can use an alternative SSE role name to SSEROLE if required. To specify a different role name, modify the 'set GRANTEE="SSEROLE"' line in the OracleBI\dwrep\createwtables.bat file.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.