Replacement for Pragma Restrict references
I have several poor answers. I hope one of them works for you.


Moving the packages to another schema may be an option. You might then grant that other schema a bare minimum set of privileges. This would get ugly for name resolution, though.
Auditing the code by searching the schema might be another option:

SELECT * FROM dba_source
WHERE schema = 'ME'
  AND name LIKE 'MYPROC'
  AND (UPPER(text) LIKE '%UPDATE %'
       OR UPPER(text) LIKE '%INSERT %'
       OR UPPER(text) LIKE '%DELETE %');

Defining the package as AUTHID CURRENT_USER would scale back the permissions at runtime to the calling user's permissions. This solution has its own can of worms.