PRODUCT_USER_PROFILE Table

The PUP table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles.

To create the PUP table

Log in to SQL*Plus as the SYSTEM user and run PUPBLD.SQL which is located in the ORACLE_HOME\SQLPLUS\ADMIN directory with:

 SQL> @%ORACLE_HOME%\SQLPLUS\ADMIN\PUPBLD.SQL 

or

1. Set an environment variable, SYSTEM_PASS, to hold the SYSTEM user login with:

   C:\> SET SYSTEM_PASS=SYSTEM/PASSWORD
   
   

   where PASSWORD is the password you have defined for the SYSTEM user. The default SYSTEM user password is MANAGER.

   PUPBLD.BAT reads this login from SYSTEM_PASS to run successfully.

2. Run the batch file, PUPBLD.BAT, from a command line prompt with:

   C:\> %ORACLE_HOME%\BIN\PUPBLD.BAT
   

If you are using SQL*Plus with a remote database, you may want to install the PRODUCT_USER_PROFILE table on the remote database. To do this, run PUPBLD.SQL on the server directly. Or, you can set the LOCAL parameter in your registry to point to the remote database and then run PUPBLD.SQL.

See the "PRODUCT_USER_PROFILE Table" in Appendix E of the SQL*Plus User's Guide and Reference for a description of the PRODUCT_USER_PROFILE (PUP) table.