PUBLIC SYNONYM - strange behaviour
I've just held a test on SQL queries for my students.
It's based on four tables in a schema and I've created public synonyms for each table and granted read privilege to PUBLIC, e.g.
CREATE PUBLIC SYNONYM staff FOR testuser.staff
GRANT SELECT ON testuser.staff TO PUBLIC
All 150+ of my students have exactly the same roles and privileges, yet two couldn't access the staff table without referring to it as testuser.staff. They have been able to access it as expected in the past.
Has anyone come across this before? I can't imagine that it's anything to do with 60 students hitting the same synonym at the same time but I do wonder.
Brian
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production