Granting privileges to the study user

Purpose—Grants database user privileges to the user that owns the study schema.
Script—grant_user_privs.sql
Where to run—Database instance for the study schema, from the folder in which the reporting software is located, for example, <Installation_Directory>\Inform\bin\DBOra\Reporting.

Open a Command Prompt window.
Change to the <Installation_Directory>\Inform\bin\DBOra\Reporting folder, for example, e:\OracleHS\InForm\bin\DBOra\Reporting.
Log on to SQL*Plus with /nolog.
Connect to the study database as a user with the privilege to grant user database privileges.
Type the following at the SQL*Plus prompt:
@grant_user_privs.sql <study schema owner>

Where:

<study schema owner>—Database user name that holds the study schema.

This script should run to completion without further prompts. The script produces a log called grant_user_privs.log. A size of 0 bytes indicates that the script was successful.

For more information, see grant_user_privs.sql.