1. Overview

When trying to use the 'Delete All Records' button on a scoped application table (sys_db_object), the following message is displayed and the records in the table are not deleted.

"Delete operation against '<table_name>' from scope '' has been refused due to the table's cross-scope access policy"


Unfortunately, the 'Delete All Records' button will not work against scoped application tables do to the cross scoping security.  Also, cross scope privilege records cannot be created using the Global scope as the Source Scope.


The workaround to this limitation would be to write a custom script to delete all the records in the table OR use the Table Cleaner.



Article Information

Last Updated:2020-05-13 09:17:20