AVDF 20.4 DBFW POLICY DOES NOT WORK WITH TOAD WHEN USING OS USER SETS (Doc ID 2808101.1)

Last updated on SEPTEMBER 26, 2021

Applies to:

Symptoms

1. Policy work fine when implemented through DB user set or IP sets for both 
 Toad and SQL Developer.  

2. Policy does not work if when implemented using 'OS User Sets'  

3. When using Toad, it shows OS username in 'All Activity Report' with domain name. i.e abc-xy\username

4. When using SQL Developer, it shows OS username in 'All Activity Report' without domain name. i.e username

   Including both OS usernames patterns (with and without domain),does not work. 

   Observation is when OS username has domain name within it, the issue encounters (might be due to special characters used in domain name like '\' 
   or '-'. 
 
 
   In AVDF 12.2, adding OS usernames with both patterns in OS User set and it works fine in 12.2 for both Toad and SQL Developer. 
 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.