Granting Privileges to the Running Account

To run Oracle JPublisher, the logged-in user must have access to the package and all database objects related to the package for which the wrapper is generated.

The apps user typically has access to all packages. It is good practice to use the apps user to run Oracle JPublisher for script generation. If the apps user cannot be used directly, you must grant privileges to the required package to the plug-in user under the apps user.

Prerequisites

Identify all procedures, related packages, tables, and other items used by the package for which the wrapper is generated.

Procedure

Execute the following SQL statements:

GRANT EXECUTE ON BOM_BO_PUB TO username;
CREATE SYNONYM BOM_BO_PUB FOR APPS.BOM_BO_PUB;

Note: To run this script, the plug-in user must also have access to tables, other packages and the tables that these packages might reference, and other objects accessed by any dependent packages. Therefore, it is good practice to run this script by using the apps user; in this case, you do not have to grant privileges to the plug-in user.