Without Database Vault installed: Use of DBMS_PRIVILEGE_CAPTURE needs licence?
Hi,
I'm using 12.1.0.2 64bit EE under SLES 11. Our database has Oracle Database Vault NOT installed:
SQL> select * from v$option where upper(PARAMETER) like '%VAULT%';
| PARAMETER | VALUE | CON_ID | 
------------------------------ ------------------------------ ----------
| Oracle Database Vault | FALSE | 0 | 
After setting up via package DBMS_PRIVILEGE_CAPTURE capturing and generating a report
afterwards, i do not see any update on the view DBA_FEATURE_USAGE_STATISTICS:
SQL> select name, detected_usages from dba_feature_usage_statistics
where upper(name) like '%PRIVI%' and dbid = ( select dbid from v$database );
| NAME | DETECTED_USAGES | 
------------------------------ ---------------
| Privilege Capture | 0 | 
So, is there a license really needed?
