Hi All,
I have a database which is on 12(12.2.0) upgraded from 11.2.0.4. There was an issue in 11.2.0.4 with product_user_profile. When ever a user login, he or she get an error (
ORA-00942: table or view does not exist Error accessing PRODUCT_USER_PROFILE). I was reading online how to fix it, and found that I need run pupbld.sql to fix it. And also found that this table (product_user_profile) is used to control) users in accessing certain sql commands by revoking access to the command. If I don't fix it, is there any impact on the database, other than restricting access to the user? Please advise.
Here is the error when connecting to the database.
e_charter@Bby>@echarter_d
ERROR:
ORA-00942: table or view does not exist
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.