Sometimes youneed to grant some permissions, for instance SELECT, on all tables in another schema.
Espacially when you use Privacy and the user for this is not the same as the tables to anonimize.
Of course this is something for a DBA, but sometimes you need to do this yourself.
- Login a Sql Query tool like "SQL Developer" with SYS permissions
PRVUSER = the schema Privacy is using
OTHERUSER = the other schema user .
- Execute this script:
FOR i IN (SELECT table_name FROM DBA_TABLES WHERE OWNER = 'OTHERUSER')
EXECUTE IMMEDIATE ('grant select on "OTHERUSER".'|| i.table_name ||' to "PRVUSER"');