PL/SQL (MOSC)

MOSC Banner

After granting all the privileges to a table, still can't do insert

edited Jul 7, 2015 10:01AM in PL/SQL (MOSC) 5 commentsAnswered

Hi there,

I run into a quite strange situation.  We are upgrading from 11i to 12.2.4 and I have to modify our ap supplier interface program.  However, when I tested run it, I got ORA-00942 table or view does not exist for ap_suppliers_int (not ap_supplier_sites_int or ap_sup_contact_int).  I am very confident the name is correct.  Plus if I run an insert statement to that table separately, it is no problem.  DBA has granted following privileges to me (bolinf is the customer domain where this package is stored and run):

SQL> grant select on ap.AP_SUPPLIERS_INT to bolinf;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center