Last updated on NOVEMBER 04, 2015
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.3 - Release: 9.2 to 11.2Information in this document applies to any platform.
Checked for relevance on 18-Nov-2011
Symptoms
Running a procedure after importing a schema dump created from a known working source fails with the following errors :
exec SCOTT.CALL_CALC_PRODUCT_PRICE(arg1, arg2);
ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SESSION", line 78
ORA-06512: at "SCOTT.STORE_BASIC_ADULT_PRICE", line 6
ORA-06512: at "SCOTT.SET_BASIC_ADULT_PRICE", line 73
ORA-06512: at "SCOTT.CALC_PRODUCT_PRICE", line 877
ORA-06512: at "SCOTT.CALC_PRODUCT_PRICE_TYPE", line 81
ORA-06512: at "SCOTT.CALL_CALC_PRODUCT_PRICE", line 60
ORA-06512: at line 1
When comparing the privileges of the SCOTT users from the two databases they are exactly the same.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms