We are upgrading from 12.1 to 12.2.11 of the EBS along with 19C database upgrade.
As we know development standards on 12.2 is entirely different and my question is about creating a new table under our custom schema. I'm running the below steps in order,
Under APPS schema,
CREATE TABLE XXCUST.XX_TEST_STG (SEQ_ID number);---Done
exec AD_ZD_TABLE.UPGRADE('XXCUST','XX_TEST_STG'); ---Done
BEGIN AD_ZD.GRANT_PRIVS('SELECT','XX_TEST_STG','READONLY'); END;---Error
Error report -
ORA-01031: insufficient privileges
ORA-06512: at "APPS.AD_ZD", line 1384
Can we give this grants directly under XXCUST schema like 12.1,
GRANT SELECT ON XXCUST.XX_TEST_STG TO READONLY;
I read in a support document that, not giving the direct grant is to avoid any invalidations on the objects that’s why oracle is recommending the API for giving any grants.
Please advise on what I need to do in order to successfully give the grant to a custom schema table.