Create operation against '' '' has been refused due to the table's cross-scope access policy

[oliolio]

Hi,

I have a business rule on a scoped table that should trigger an insert in a table in the global application but i keep getting the "Create operation against '' '' has been refused due to the table's cross-scope access policy" error. 

So far i've tried the following. 

Checking all the checkboxes under "Application access" for the target table, created Cross-scope privileges for all types of operations (including execute API) for the target table and we've also tried Restricted Caller Access Privileges where we've added the privileges. 

Nothing seems to work. 

Does anyone have any suggestions?

Best Regards
Ola 

[Draes · Accepted solution]

This has been resolved by marking the table refusing the cross-scope access policy as "Track in Update Sets".

[Riro1]

I dont see the Track in Update Sets. How did you turn it on?

[Joe72]

If you don't see that UI Action, chances are that the table already extends from sys_metadata and that this is not your issue. However, if you check your table and discover that it is not extended from sys_metadata, the UI Action may have been deactivated or deleted.

That all being said, I'm facing an interesting issue where the db_image table is not allowing me to create a record from a scoped app. The db_image table extends from sys_metadata, the table has been set to allow from all scopes and all checkmarks have been checked (Read, Write, Create, Delete). I have even manually created the cross-scoped privilege, but still I'm being denied access. Cleared cache and logged off/back on and still nothing. Anyone have some ideas?

[Ton ThalesNL]

I had this issue and found 3 hits on this subject, the 3th one fixed it for me:

1. The Table access properties
2. Excellent blog on cross scope access in general
3. Instance (cross-scope access) Cache issue