MISSING GRANTS

SELECT 'grant select on ' || :src_schema || '.' || object_name || ' to ' || :target_schema || ';' AS grant_cmd FROM (
SELECT tabs.table_name AS object_name FROM all_all_tables tabs WHERE tabs.owner = :src_schema AND NOT EXISTS (
  SELECT * FROM all_tab_privs privs WHERE privs.table_schema = :src_schema AND privs.table_name = tabs.table_name AND privs.grantee = :target_schema
)
UNION
SELECT seqs.sequence_name AS object_name FROM all_sequences seqs WHERE seqs.sequence_owner = :src_schema AND NOT EXISTS (
  SELECT * FROM all_tab_privs privs WHERE privs.table_schema = :src_schema AND privs.table_name = seqs.sequence_name AND privs.grantee = :target_schema
)
ORDER BY object_name
)
;