Moneycontrol Brokerage Recos

Sunday, April 26, 2015

Error accessing PRODUCT_USER_PROFILE

PRODUCT_USER_PROFILE:


You may occasionally find some errors like the following when new users you have created try to access the database through SQL*Plus:

Error accessing PRODUCT_USER_PROFILE

Warning:  Product user profile information not loaded!

You may need to run PUPBLD.SQL as SYSTEM


The product_user_profile table is a table Oracle maintains to control access to the database through SQL*Plus. Make sure you are logged in as the SYSTEM user and run the following script to ensure that this table can be accessed properly by all the database users exist, so that their SQL*Plus privileges can be checked properly.

SQL> @ORACLE_HOME/sqlplus/admin/pupbld.sql
DROP SYNONYM PRODUCT_USER_PROFILE
.............
.............
.............
Synonym created.
SQL>

No comments:

Post a Comment