I think globally accessed contexts and VPD are the most underused database security mechanisms. Probably, it’s because they’re still a bit unknown despite of being here since Oracle 9. I created this simple themo those days that it’s still valid today. The demo contains the database objects needed to implement an VPD policy and a web application using those globally accessed contexts. The demo contains also a README file explaining it in detail. You can download it from this link.