Database Security Products (MOSC)

MOSC Banner

Without Database Vault installed: Use of DBMS_PRIVILEGE_CAPTURE needs licence?

edited Dec 12, 2019 8:28AM in Database Security Products (MOSC) 4 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center