Error accessing PRODUCT_USER_PROFILE Warning: Product user profile information not loaded! You may need to run PUPBLD.SQL as SYSTEMOccurred after restoring the database and attempting to login via SQL*Plus
Solution:run @?/sqlplus/admin/pupbld.sql script while being logged in as SYSTEM user, to install the SQL*Plus PRODUCT_USER_PROFILE tables. This table allows SQL*Plus to disable commands per user.
Important:Run this script logged in as SYSTEM user, not SYS. When loggin in to SQL*Plus using connect as sysdba, you end up being logged in as SYS account. To double-check, run "show user" command
No comments:
Post a Comment