| APEX - can't insert/update in an specific schema [message #297547] |
Fri, 01 February 2008 05:33  |
AdeleSwart
Messages: 3
Registered: January 2008
|
Junior Member |
|
|
Good day,
We are trying to insert/update data in a specific schema(lookup) in a workspace(MMS) without any luck. We get the following error:
---------
ORA-20001: Error in DML: p_rowid=1, p_alt_rowid=COMPANY_NO, p_rowid2=P, p_alt_rowid2=ADDRESS_TYPE_IND. ORA-01031: insufficient privileges
Error
Unable to process row of table COMPANY_ADDRESS.
OK
---------
We can insert/update in SQLDeveloper or SQL+ but not via APEX.
We've signed in as the developer on APEX and then checked on Oracle what username is used – APEX_PUBLIC_USER. Then I’ve given the apex_public_user permissions on Oracle to the following:
grant delete any table to apex_public_user;
grant insert any table to apex_public_user;
grant select any table to apex_public_user;
grant update any table to apex_public_user;
grant select any sequence to apex_public_user;
grant execute any procedure to apex_public_user;
I’ve also linked the MMS workspace to the lookup, mms and the util schemas. The developers can insert/update the tables in the mms and util schemas, but not the lookup schema. They say this happens on any page where they want to insert/update in the lookup schema.
Thank you
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
