I am using Oracle Autonomous Database on OCI. I want to create a foreign key in one of my schemas that references a view in APEX_230200
schema. I executed the statement below using ADMIN
user (which is AFAIK the highest privileged users in Autonomous Database):
grant REFERENCES on APEX_230200.apex_appl_acl_users TO myfin;
I got the following error:
grant REFERENCES on APEX_230200.apex_appl_acl_users TO myfin
Error report -
ORA-01031: insufficient privileges
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to perform a database operation without
the necessary privileges.
*Action: Ask your database administrator or designated security
administrator to grant you the necessary privileges
What am I missing?