
Oracle Database 12c Security Cookbook
By :

In this recipe, you'll view the collected data about the unused system privileges during the capture interval.
You'll need an existing user who can create a privilege analysis policy (has the CAPTURE_ADMIN
role and the SELECT ANY DICTIONARY
privilege), for example, the SYSTEM
user.
Connect to the database as system or a user who has appropriate privileges:
$ sqlplus system
View that the user Alan
has used all system privileges that have been granted to him (there are no unused system privileges):
Figure 45 - The unused system privileges for the user Alan during the database policy ALL_PRIV_POL capture interval
To view report about the unused system privileges in EM12c, see instructions to view the used system privileges and under Privilege Analysis: Reports, choose the Unused tab instead of the Used tab.