Create the rptinstall user on the InForm database server and the Reporting database server for DiffDB

Previous Topic

Next Topic

Book Contents

Create the rptinstall user on the InForm database server and the Reporting database server for DiffDB

  1. Open a Command Prompt window.
  2. Log in to the study database with a user that has sysdba privileges. Make sure that the connection is made with the as sysdba clause.
  3. Run this command:

    create user rptinstall identified by <dbauser_study_password> default tablespace <tablespace_name> temporary tablespace <tablespace_name>

    <dbauser_study_password>—The password for rptinstall, the database user for the study. This password is case-sensitive.

    <tablespace_name>—A valid tablespace name in the database. Oracle recommends that you do not use the SYSTEM tablespace for the default tablespace.

    Note: The default tablespace does not require additional room for objects, because the rptinstall user does not own objects.

  4. Type the following at the SQL*Plus prompt:

    @grant_dba_privs rptinstall

    The grant_dba_privs.sql script is located in the <Installation_Directory>\InForm\bin\DBOra folder.

    For more information, see grant_dba_privs.sql.

Send Feedback