Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: "Product user profile information not loaded"? Why?

Re: "Product user profile information not loaded"? Why?

From: Bosse Melin <bosse.melin_at_gislaved.mail.telia.com>
Date: 1997/03/11
Message-ID: <01bc2e72$26182fc0$4bfcc6c3@bome>#1/1

You need to run the SQL script PUPBLD.SQL to fix this. Scan your $ORACLE_HOME directory for the file and start the script from SQL*Plus connected as SYSTEM.
Below you can se the header from the PUPBLD.SQL script : rem

+---------------------------------------------------------------------+
rem  |  PUPBLD.SQL -- CREATE PRODUCT AND USER PROFILE TABLES              

|
rem |
|
rem | Connect as SYSTEM before running this script
|
rem |

|

 rem | This script is used by the DBA to create the product_profile and
|

 rem | user_profile tables in the SYSTEM account.
|

 rem | There are two views, product_privs and user_privs, which are what
|

 rem | a user will see as product_profile and user_profile. They allow
|

 rem | the user to see (and in the case of user_profile, modify) only
|

 rem | their own privileges or profiles.
|

rem
+---------------------------------------------------------------------+

Best regards

Bosse Melin, bosse.melin_at_gislaved.mail.telia.com Received on Tue Mar 11 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US