SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00942 Table or View does not exist when running a procedure

Jim ThompsonMar 12 2012 — edited Mar 12 2012

Hi,

I have a procedure called FND_GLOBAL under a schema called APPS and I have granted execute privilege on this procedure to another schema called CIVICA

However when I run the procedure from the CIVIC schema I get

ORA-00942 Table or view does not exist
ORA-06512 at APPS.FND_CORE_LOG, line 25
ORA-06512 at APPS.FND_GLOBAL, line 104
ORA-06512 at APPS.FND_GLOBAL, line 1620
ORA-06512 at APPS.FND_GLOBAL, line 2171
ORA-06512 at APPS.FND_GLOBAL, line 2313

I am guessing some of the sub components also need to be granted to CIVICA ?

What way does Definer's rights work ? Should the sub components not also be accessible via this procedure being owned / defined by Apps but being executed by CIVICA ?

Jim

This post has been answered by Frank Kulash on Mar 12 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2012

Added on Mar 12 2012

11 comments

1,987 views