4.5 Compliance with Oracle Database Security Policies

Oracle Big Data SQL external tables follow the exact same Oracle security policies as other Oracle tables. Users and roles are granted or revoked privileges on the tables.

Advanced security policies, such as redaction and row level security may also be applied. These rules are layered on top of the privileges specified in Hadoop. This means that even when the underlying data source does not have support for advanced security features, such as redaction, those polices can still be enforced when you use Oracle Big Data SQL.