In this recipe, you'll view collected data about the unused object 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 which object privileges the user
Alan
has used during the database policy capture interval:
In EM 12c, after you have generated the report, select the policy, and from Actions drop-down menu, select Reports. The Usage Summary report will open. Click on the Unused tab and verify that the user Alan
hasn't used the INSERT
and UPDATE
privileges while ALL_PRIV_POL
has been active.