Create the rptinstall user on the InForm database server and the Reporting database server for DiffDB
- Open a Command Prompt window.
- 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.
- 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.
- 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.