Thursday, 17. October 2019., 15:25
Data Protection is becoming more relevant, especially now that GDPR is a thing. Of course it is easy enough to add predicates to your reports and restrict the data shown. But how do you handle data entry?Implementing this level of security can be handled by the application, but we all know this is not the way to do it. What if the user downloads SQLcl or SQLDeveloper and sets up a connection to the database? What if we want to expose part of the data as REST Services? The most logical place to protect data is as close to where the data is stored, being the database.The Oracle database offers several methods to keep data private, such as Virtual Private Database, Redaction and Label Security to name a few.This session will cover these techniques and will show you how to interact with APEX applications.