After granting all the privileges to a table, still can't do insert
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;